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.

N272AAirtrade Aviation Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedS/N 3433161 N272AAEdj Aviation Limited · Fort Myers Beach, FLBuilt 1960 · S/N CD-34 N272BBearair II LLC · Libertyville, ILBuilt 1975 · S/N 18264193 N272CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881006 N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824 N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821 N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857 N272ECBurchett Michael · Bettendorf, IABuilt 1981 · S/N 28-8111081 N272FDFly Dynasty Corp · Ocala, FLBuilt 1968 · S/N 28-24693 N272GBaudouin Dameries · Pagosa Springs, COS/N 27-4189 N272GTNfh Aviation LLC · Pikeville, KYS/N 44-7995054 N272HWHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020272 N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439 N272KSOlson Richard · Eau Claire, WIBuilt 1967 · S/N 28-23936 N272LCPen And Pilot Inc · Flagler Beach, FLBuilt 1972 · S/N 28R-7235059 N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429 N272NSKroeber Thomas · Pawlet, VTBuilt 1980 · S/N 18267402 N272PSNormandie Air LLC · Santa Clara, CAS/N D-4056 N272QFlying Docs LLC · Tomball, TXBuilt 1966 · S/N TE-236 N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700 N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914 N272SBofinger Jr John M · Hewitt, NJBuilt 1965 · S/N D-8002 N272SCRobert Gardner Enterprises LLC · Mercer, MEBuilt 1977 · S/N 18052939 N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272VWigley Ben Jr · Huntington, ORBuilt 1956 · S/N 33362 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N273Lone Star Sorties LLC · Dickinson, TXS/N D-1340 N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930 N2730RRp Aviation Inc · Alliance, OHBuilt 1978 · S/N CE-792 N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429 N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530 N2731DVoegeli Nathan · Sacramento, CAS/N 25273 N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045 N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265 N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931 N2731TFocus LLC · Missoula, MTBuilt 1967 · S/N D-8454 N2731UKemp Gilbert A · Waterville, NYBuilt 1963 · S/N 17250331 N2731WUsrey Curtis R · Sullivan, INBuilt 1966 · S/N 1033 N2732DYounger Cody M · Shedd, ORBuilt 1952 · S/N 25274 N2732GPrince Benjamin D · Lincoln, MTS/N 52032 N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046 N2732LGlenndale LLC · Jackson, MOBuilt 1967 · S/N 17255932 N2732UDavenport Jimmy J · Hayesville, NCS/N 17250332 N2732WReik Martina · Novi, MIBuilt 1966 · S/N 1034 N27339Rice John G · Craig, AKBuilt 1970 · S/N 18052140 N2733CYurechko Philip Jr · Jewett City, CTBuilt 1954 · S/N 26277 N2733FMetzger William M · Boonville, INBuilt 1965 · S/N 18256833

Back to AD 98-21-21 R1