Registered aircraft · 56,580

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3368FA&W Air LLC · Aiken, SCBuilt 1966 · S/N 18257368 N3368RRegistered aircraftAssigned, pending cancellationS/N 18258668 N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168 N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668 N3368UZeigler Ryan C · The Dalles, ORBuilt 1963 · S/N 18254768 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N3369FJ P Aero Holdings Inc · Carson City, NVS/N 18257369 N3369RFenton Flyers Inc · Hillsboro, MOBuilt 1967 · S/N 18258669 N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169 N3369TBauer Charles · Graceville, MNS/N 17700669 N336ADKropp Christian Trustee · Azle, TXBuilt 1963 · S/N 336-0054 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336BHAce Aviation LLC · Mankato, MNBuilt 1964 · S/N 3360125 N336CFRobbins Warren N · Chandler, AZS/N 336-0174 N336DDNewman Christopher J · Lorena, TXBuilt 1960 · S/N 47254 N336FLLambright Jerry A · South Daytona, FLBuilt 1964 · S/N 336-0177 N336GMGlasser Dean · Boswell, PAS/N R1722336 N336JBBarney Julius C · Lutz, FLBuilt 1963 · S/N 336-0071 N336JLErickson Paul · Okahumpka, FLS/N 336-0181 N336JWMusgrove Jimmy Wayne · Delta Junction, AKBuilt 1964 · S/N 336-0189 N336LBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 336-0117 N336LVMarti Jorge · Miami, FLBuilt 1964 · S/N 336-0176 N336MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12880 N336RSAirspeed Marketing LLC · Phoenix, AZS/N 17252228 N336TWPair Of Minutes LLC · Marshville, NCBuilt 1963 · S/N 336-0147 N336VRVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0024 N336W336 LLC · Eagle, IDBuilt 1963 · S/N 336-0156 N33702Hood Frank A · Burlington, NCBuilt 1967 · S/N 337M-0142 N3370SWittenborn Grant A · Olathe, KSBuilt 1973 · S/N 18502281 N3370UBriannas Wings Of Passion Foundation Inc · Magalia, CABuilt 1963 · S/N 18254770 N3370VHolladay Aviation LLC · Jacksonville, FLBuilt 1974 · S/N 15076477 N3370YBrink Brittnie L · Baldwin, WIBuilt 1962 · S/N 18254370 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3371FRavens Rebuilders Inc · Ellenboro, WVS/N 18257371 N3371LAgresti Harold David · Ceres, CABuilt 1967 · S/N 185-1323 N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671 N3371YChavers Finley L · Newnan, GABuilt 1962 · S/N 18254371 N3372DWings Like Eagles Aviation LLC · Newnan, GABuilt 1955 · S/N 32170 N3372FSwanner Robert Craig II · Water Valley, MSBuilt 1966 · S/N 18257372 N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172 N3372ULeading Edge Operations LLC · Knoxville, TNBuilt 1963 · S/N 18254772 N3372VSimmons Robert J · Rising Fawn, GABuilt 1974 · S/N 15076478 N3373BManley Steven T · Dallas, TXBuilt 1965 · S/N 17253577 N3373DCarpenter Marshall Owen · Isanti, MNBuilt 1956 · S/N 32171 N3373LHowell Nicholas A · Englewood, COBuilt 1967 · S/N 185-1325 N3373RSkylane N3373r LLC · Rancho Cucamonga, CABuilt 1967 · S/N 18258673 N3373SWestern Metal Products LLC · Ellensburg, WABuilt 1964 · S/N 18255390 N3373URms Industrial Sales LLC · Neenah, WIBuilt 1963 · S/N 18254773 N33748Mcgowan Daniel J · Springville, CAS/N 18052525 N3374DScootair LLC · Alburgh, VTBuilt 1955 · S/N 32172

Back to AD 79-10-14 R1