Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672 N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395SGarcia Robert W · Floresville, TXFirst renewal noticeS/N 18264956 N1395TLegacy Aerospace Industries LLC · Miami, FLS/N 28R-7235277 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673 N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095 N13966Chesapeake Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1970 · S/N 27-4581 N1396AEsser J Randolph Trustee · Birmingham, ALBuilt 1969 · S/N D-9012 N1396DFlying Dutchman Aviation LLC · Richmond, TXBuilt 1951 · S/N 19972 N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674 N1396YGarrison Shannon · Pangburn, ARS/N 17249096 N1397HIngold Terry L · Albemarle, NCS/N 34-7770124 N1397MRichs Inc · Wilmington, DES/N 21061940 N1397SKnotty Aviation LLC · Fort Myers, FLBuilt 1976 · S/N 18264958 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675 N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097 N1397ZJ&W Air LLC · Asheville, NCBuilt 1961 · S/N D-6819 N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598 N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600 N13984Smith Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1970 · S/N 27-4602 N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398SOff The Charts LLC · Kalispell, MTBuilt 1976 · S/N 18264959 N13998Granger Vic · Union Grove, ALS/N 27-4616 N1399MRegistered aircraftBuilt 1975 · S/N 18264314 N1399SDesmond Brett Kyle · Mars, PABuilt 1976 · S/N 18264960 N1399TLauff Samuel Jr · Ocala, FLBuilt 1972 · S/N 28R-7235278 N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070 N139ARSky West Aviation Inc Trustee · Albuquerque, NMS/N 25557 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570 N139DBWolfe LLC · Rogers, TXS/N 27-4611 N139DMMurillo Raymond A · Pico Rivera, CABuilt 1969 · S/N 28R-35262 N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174 N139GGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 28-8211036 N139MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496541 N139PTCroley John T Jr · Fitzgerald, GABuilt 1964 · S/N TC-758 N139QMoles Timothy E · New Cumberland, WVBuilt 1964 · S/N TC-638 N139ROlsen David A · Marinette, WIBuilt 1978 · S/N D-10083 N139SNMccullough Jacob D · Lockhart, TXBuilt 1965 · S/N 28-2184 N139TATell Christopher A · Colville, WABuilt 1974 · S/N D-9652 N139YPSmuzzle Air LLC · Longboat, FLBuilt 1977 · S/N 28R-7703364 N13AGWeather Modification LLC · Fargo, NDBuilt 1977 · S/N 34-7770115 N13AKTailwinds Inc · Toms River, NJBuilt 1975 · S/N TH-678 N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009 N13ARKeen Daniel Edward · Peoria, AZBuilt 1954 · S/N D-3885 N13BJSevcik Clint · Medford, MNS/N 21058486

Back to AD 98-21-21 R1