Registered aircraft · 40,394

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N9226DClf Industries LLC · Thornton, COBuilt 1958 · S/N 22-6286 N9226HDebt LLC · Yuma, AZBuilt 1975 · S/N 17266026 N9226SSpencer Montgomery L · Clinton, SCBuilt 1975 · S/N M-1723 N9227JBinns George E · Hackettstown, NJBuilt 1966 · S/N 28-3297 N9227MMullis Brent S · Garfield, GABuilt 1966 · S/N 3442 N9227WMasterman Robert David · Chugiak, AKS/N 11097C N9228DLavender James R · Gainesville, TXBuilt 1958 · S/N 22-6288 N9228LRegistered aircraftBuilt 1993 · S/N 14024C N9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391 N9229DStevens Mark F · Ocean Springs, MSBuilt 1958 · S/N 22-6289 N9229JUnterschuetz Phillip David · Ladysmith, WIBuilt 1966 · S/N 28-3299 N9229SRegistered aircraftBuilt 1975 · S/N M-1724 N922CTSweptwing Holdings LLC · Houston, TXS/N 1064 N922EAButler Ronald A · Cumming, GAS/N 17263921 N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557 N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558 N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290 N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791 N92318Flitepro Inc · Murrieta, CAS/N 17261561 N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302 N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562 N9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305 N9232RRogers Ricky R · Saint Francis, KSS/N 19003C N9232TSannella Joseph J · Missoula, MTS/N 19002C N9232VFerri Lawrence E · Lake Worth, FLBuilt 1969 · S/N 690056 N9234ACruz Salvador A · Sumter, SCS/N 21001C N9234ELdg LLC · Kalispell, MTBuilt 1992 · S/N 14033C N9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232 N92356Hub City Aviation Academy LLC · Lubbock, TXBuilt 1973 · S/N 17261567 N9235CWilliams Patrick S · Saint Paul, MNBuilt 1978 · S/N 28-7890392 N9235SKaidor Jerome L · Hayward, CABuilt 1975 · S/N M-1727 N92362Yeakley Gary G · Ontario, CABuilt 1993 · S/N 19006C N9236HOptic Air LLC · Sioux Center, IABuilt 1975 · S/N 17266034 N9236SMahi Aviation Corp · Winter Garden, FLNon-citizen corporation, flight hours not reportedBuilt 1975 · S/N M-1728 N9236YSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 19008C N9237JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1989 · S/N 2841123 N9237VPortouw Lawrence J · Huachuca City, AZBuilt 1969 · S/N 690058 N9238KCrow Wing Flying Club Corp · Nisswa, MNFirst renewal noticeBuilt 1976 · S/N 28-7690233 N9238NBloomberg David C · Northampton, MABuilt 1993 · S/N 19012C N9238SAllt International LLC · Parker, COBuilt 1976 · S/N M-1760 N9239JAshmore Benjamin H Jr · Austin, TXBuilt 1966 · S/N 28-3313 N9239SRoyer Richard W · Winnebago, MNBuilt 1975 · S/N M-1732 N9239VRegistration Pending · Louisville, MSRegistration pendingBuilt 1969 · S/N 690059 N923ACWarnock Tony J · Mobile, ALBuilt 1990 · S/N 42 N923EZE Z Air LLC · Wilmington, NCBuilt 1966 · S/N 3458 N923KMWilliams Zackery · Lake Tapps, WABuilt 1993 · S/N 20008 N923SMN923sm LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1923M N923TEDiscover Resources LLC · Norman, OKBuilt 2001 · S/N 10202 N923VDog House Aviation LLC · Mount Pleasant, SCBuilt 1974 · S/N M-1591 N9240HPropability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17266038

Back to AD 79-10-03 R2