Registered aircraft · 85,612

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.

N28KUIal Corp · Lewes, DES/N 2881142 N28LArkad Ventures LLC · Coral Gables, FLS/N 28-20841 N28LDDancing Bear LLC · Polson, MTBuilt 1970 · S/N D-9205 N28LEGlenn Scott A · Overland Park, KSBuilt 1976 · S/N 28R-7635253 N28LFBaker Timothy Scott · Shreveport, LABuilt 1973 · S/N 18261898 N28LZLindemann Thomas · Gustine, CABuilt 1981 · S/N U20606531 N28MBMockingbird Flying Club Inc · Sioux Falls, SDBuilt 1980 · S/N 28-8090292 N28MCWood Virgil Jay · Sandy, UTS/N 28R-7931271 N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535 N28NBBeckwith James N · Goldsboro, NCBuilt 1969 · S/N 28-26157 N28NCHurley Thomas W · Plymouth, MABuilt 1968 · S/N 28R-30357 N28NDN28nd LLC · Ambrose, GABuilt 1968 · S/N 28-4621 N28NSMockingbird Flying Club · Sioux Falls, SDBuilt 1976 · S/N 28-7790227 N28NTHammock Flying Service Inc · Black Rock, ARBuilt 1975 · S/N 310R0243 N28NZNzaviation LLC · Mesa, AZBuilt 1973 · S/N 28-7305003 N28PABurke Jacob R · Cornelius, NCS/N 28-3410 N28PGLane Community Colleg · Eugene, ORBuilt 1979 · S/N 28-7916405 N28PPPiper Aircraft Inc · Vero Beach, FLBuilt 2019 · S/N 2881041 N28PVJordak Thomas · Simpsonville, SCBuilt 1978 · S/N 32R-7985008 N28PWGoodnight Ranch Co · Englewood, KSBuilt 1965 · S/N 18256064 N28PZAsa Obion LLC · Union City, TNBuilt 2006 · S/N 3257418 N28QWBack Mark D · Washington, DCBuilt 1974 · S/N 28-7425223 N28RInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N 2890202 N28RAStires Steven D · Germantown, TNBuilt 1964 · S/N 28-20510 N28RSElohim Airparts Sales LLC · Naples, FLBuilt 1970 · S/N 21059316 N28SGMarshall Robert W · Hemet, CABuilt 1956 · S/N D-4540 N28SKAdamski Walter E Sr · Auburndale, FLBuilt 1968 · S/N 28-24940 N28SRM & M Aero LLC · Wilmington, DEBuilt 1962 · S/N TD-524 N28STParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020129 N28SWShiftta LLC · Ramrod Key, FLBuilt 1979 · S/N 28R-7931308 N28TJNational Marketing And Management Services LLC · Clyde Park, MTBuilt 1979 · S/N TC-2218 N28TLTml Aircraft Inc · Narrowsburg, NYBuilt 1975 · S/N 28-7515412 N28UPStoddard Donald W · Great Falls, MTBuilt 1973 · S/N 28R7335386 N28VTOwens Curtis R Jr · Jourdanton, TXBuilt 1978 · S/N TC-2184 N28WBMulder Air Inc · Renville, MNBuilt 1968 · S/N D-8729 N28WJAerinova Inc · Mattoon, ILBuilt 1978 · S/N 17270054 N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626 N28WTHangar 14 Maintenance Solutions LLC · Santa Teresa, NMFirst renewal noticeS/N 28-2288 N28WVOrth Duane C · San Antonio, TXBuilt 1978 · S/N TJ124 N28WWCruse Lonnie · Chandler, AZBuilt 1967 · S/N 28-10910 N28XArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1964 · S/N 347 N29000Bevins William Brian · Phoenix, AZBuilt 1967 · S/N U206-1000 N29001Geske Sales & Service · Enderlin, NDBuilt 1974 · S/N 17264092 N29002E A B Services LLC · Cape Coral, FLBuilt 1972 · S/N 21059777 N29003R J Kielty Plumbing Heating And Cooling Inc · New Port Richey, FLS/N 21059778 N29006Fancy Inc · Iowa City, IABuilt 1974 · S/N 17264093 N2900ATct Aerial LLC · Waukesha, WIBuilt 1953 · S/N 30100 N2900ECentaurus LLC · Ontario, CABuilt 1978 · S/N 17271368 N2900FSciathan LLC · Grosse Pointe, MIBuilt 1966 · S/N 18257000 N2900HStevens Cloyce B Jr · Tillar, ARS/N 34-7970342

Back to AD 98-21-21 R1