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.

N2208GAskerli Auto LLC · Kalispell, MTBuilt 1958 · S/N 51508 N2208TThurmond Donald · Madison, GAS/N 28-7105185 N22097Crestair Air LLC · Dover, DEBuilt 1977 · S/N E-1169 N22099Falwell James C · Beaufort, NCBuilt 1978 · S/N CE-749 N2209DMaas Michael H · Mendota, ILBuilt 1952 · S/N 20361 N2209EIngersoll George P · Lakewood, COBuilt 1978 · S/N 17271188 N2209LOrth Duane C · San Antonio, TXBuilt 1976 · S/N D-9940 N2209PRuppel Robert E Jr · New Orleans, LABuilt 1967 · S/N 27-3788 N2209RPilotsgirl LLC · Goldsboro, NCBuilt 1968 · S/N T210-0359 N2209TSngdo Aviation LLC · Spring Hill, FLBuilt 1971 · S/N 32-7140070 N2209VChinn Timothy D · Austin, TXBuilt 1979 · S/N 28-7990343 N2209YSparks Samuel Derring Jr · Dewey, OKBuilt 1979 · S/N 28-7921015 N220AAerospace Aviation Services Inc Trustee · Wilmington, DEBuilt 1965 · S/N TC-866 N220AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496617 N220BDAlexander Nathan D · Melrose, IABuilt 1964 · S/N 2862 N220BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881957 N220BRSimmonds Gary Bert · San Antonio, TXBuilt 1977 · S/N 310R0973 N220BXDangberg Dennis · Wayne, NEBuilt 1972 · S/N TC-1462 N220CEMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881530 N220DKey Larry Wallace II · Early, TXBuilt 1958 · S/N D-5642 N220DSChagrin Valley Biplanes LLC · Chagrin Falls, OHBuilt 1960 · S/N DH-271 N220FCRegistered aircraftBuilt 1993 · S/N 24-3282 N220FLChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496479 N220GBryant Tyrone L · Bigfork, MTS/N D-6657 N220GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 3449362 N220HDAce Transport Service Inc · Wilmington, DEBuilt 1975 · S/N 310R0593 N220JGArchies Wings LLC · Umatilla, FLBuilt 1978 · S/N 28-7990067 N220KALexatys LLC · Laurel, DEBuilt 1982 · S/N 34-8233151 N220KCAvanti Air Co · Troy, MIBuilt 1989 · S/N 3433137 N220LLife Chiropractic And Wellness Center Inc · Prudenville, MIBuilt 1977 · S/N 32R-7780393 N220MEBoyle Flying Service Inc · Boyle, MSBuilt 1967 · S/N U206-0797 N220MGCornwell Anne L · Athens, OHBuilt 1978 · S/N 28R-7837156 N220MWLampert Aviation LLC · Phoenix, AZBuilt 1977 · S/N E-1063 N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N220RMBenner Gregory T · Youngsville, NCBuilt 1978 · S/N 32R-7887161 N220RPDanzig Peter B · Menlo Park, CABuilt 1988 · S/N E-2438 N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593 N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153 N220TGSeneca Tank Inc · Des Moines, IABuilt 2002 · S/N 3449265 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220TMMoore Wistar III · Savannah, GABuilt 1993 · S/N 24-3303 N220VStartz John D · Dallas, TXBuilt 1969 · S/N TC-1235 N220VVSmith Peter I Trustee DBA · Ocala, FLBuilt 1989 · S/N 3433140 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N220WRExecutive Services Inc · Columbus, MSBuilt 1994 · S/N E-2909 N220WSClark Alan R · Tucson, AZBuilt 1978 · S/N R18200260 N220WXMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881540 N220XPOleary Patrick G · Lake Tapps, WAS/N T310Q01020 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N2210DSample Richard F · Ellensburg, WAS/N 20362

Back to AD 98-21-21 R1