Registered aircraft · 40,395

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.

N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119 N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496 N20MZChakraborty Imon · Auburn, ALBuilt 1998 · S/N 001 N20NASchneider Adam R · Hutchinson, KSBuilt 1977 · S/N AA5B-0560 N20PGSteiner Gregory L · Fort Lauderdale, FLBuilt 1966 · S/N 28-22276 N20PPTullgren Michael · Lincoln, CABuilt 1956 · S/N 22-4554 N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227 N20RDickerson Stephen R · Frisco, TXBuilt 1960 · S/N 24-1684 N20RTTyson Richard E · Barton, FLBuilt 1966 · S/N 3309 N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20SBBrillaud Stephen A · Germantown, TNBuilt 1976 · S/N 917-76 N20SCTriple S Air LLC · Atchison, KSBuilt 2000 · S/N 2678 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658 N20WTRice James L · Mckinney, TXBuilt 1982 · S/N SW01 N20YBBurdick Rich · Montrose, COFirst renewal noticeBuilt 1964 · S/N 2708 N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41 N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888 N2101EV1 Aviation LLC · Englewood, COBuilt 1978 · S/N 17271155 N2101UVansurdam John R · Seneca, SCBuilt 1961 · S/N 147 N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471 N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785 N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130 N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156 N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461 N2102VGiovanini Terry L · Bozeman, MTBuilt 1954 · S/N 182663 N21030Aircraft Management Group Inc · Honolulu, HIBuilt 1978 · S/N 28-7816529 N21035Hayes Bradley M · Grove, OKBuilt 1974 · S/N 17263890 N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450 N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271 N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327 N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444 N21052Registered aircraftN-number assigned, not yet registeredS/N 28-7916023 N2105UPiper Automotive & Marine Service Inc · North Miami, FLBuilt 1979 · S/N 28-7990328 N2105WNenow William R · Tulare, CABuilt 1973 · S/N M-1433 N21065Omni Management LLC · Decatur, ALS/N 28-7990033 N2106CRunde Dean G · Riceville, IAS/N 28-7916131 N2106WGemma Aviation LLC · Duncan, SCBuilt 1973 · S/N M-1474 N2107DBreslow Arnold M · Dania, FLBuilt 1978 · S/N 28-7916142 N2107EFly Kilo Charlie LLC · New Century, KSBuilt 1978 · S/N 28-7916162 N2107WIguana Aviation LLC · Chicago, ILBuilt 1973 · S/N M-1437 N2108CMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7990142 N2108ERedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 17271159 N2108PGlover William S · Mount Pleasant, TXBuilt 1956 · S/N 23-698 N2109BSchilling Aviation LLC · Britton, MIBuilt 1948 · S/N 6536 N2109NStallings Farms Trucking LLC · Hertford, NCBuilt 1979 · S/N 28-7990274 N210ANCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17264678 N210EZFaulkison Brian S · Watkins, COBuilt 1978 · S/N 28-7990077 N210JAThroneburg Jason J · Lecanto, FLBuilt 1979 · S/N AA5A-0882 N210SKPray Aviation Inc · Augusta, KSBuilt 1960 · S/N TD-393

Back to AD 79-10-03 R2