Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N6496LTurn Key Aviation LLC · North Las Vegas, NVBuilt 1980 · S/N 15284420 N64971R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281505 N64972Fixed Wing Holding Company Inc · Pembroke Pines, FLS/N 17275662 N6497BVeve Rafael A · Indn Hbr Bch, FLBuilt 1957 · S/N 29697 N6497EPeoples Mike · Rockwall, TXBuilt 1980 · S/N 18504050 N6497GLynch David C · Columbus, INBuilt 1970 · S/N 15071997 N6497XPeebles Thomas O · Elma, WABuilt 1961 · S/N 18050997 N64985Keenan Jim · Neenah, WIBuilt 1978 · S/N 15281512 N64987Stanford Jay J · St Marys, GAS/N 15281514 N64988Southwinds Export Inc · Kissimmee, FLS/N 15281515 N64989Verderame Robert A · Metairie, LABuilt 1978 · S/N 15281516 N6498BDunlap Paul C Jr · Rock Island, TNBuilt 1956 · S/N 29698 N6498ECallender Roy A Jr · Ennis, TXBuilt 1959 · S/N 46598 N6498FWisener Randall G · Addison, ALBuilt 1979 · S/N 17273232 N6498VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N T30300313 N6499ATreetop Flying Circus LLC · Niceville, FLBuilt 1956 · S/N 33299 N6499BMoore Thomas W · Zimmerman, MNFirst renewal noticeBuilt 1957 · S/N 29699 N6499EAzevedo Manuel J · Modesto, CABuilt 1959 · S/N 46599 N6499FMacintosh William J · Simpsonville, SCBuilt 1975 · S/N 18264207 N6499GSkadberg Christen G · Knife River, MNBuilt 1970 · S/N 15071999 N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073 N649ARSmith Roy Dennis · Buckeye, AZBuilt 1959 · S/N 55953 N649ESFlymore Aviation LLC · Philadelphia, PABuilt 1975 · S/N 172-64536 N649GCAviation Paradise LLC · Homestead, FLBuilt 1979 · S/N 17273413 N64AJN64aj LLC · Winterset, IAS/N 18052364 N64BBBlazey Brian I · Palmyra, NYBuilt 1967 · S/N 15066150 N64CASwaz Aviation LLC · Mesa, AZBuilt 1981 · S/N 17275269 N64CVValle Richard · Wellington, FLBuilt 1963 · S/N 205-0508 N64DBFyrberg Forest M · Oakland, MES/N 180-52084 N64EFHampton Flying Services LLC · Portsmouth, NHBuilt 1973 · S/N 17262871 N64NEllegood Michael S · Prescott, AZBuilt 1974 · S/N P3370196 N64PDPapa Delta LLC · Eddyville, KYBuilt 1979 · S/N 17272996 N64RBBurnett Ramon R · Alpine, CABuilt 1968 · S/N 18258811 N64RKKoril Richard A · Overgaard, AZBuilt 1964 · S/N 18255686 N64SN81c Corp LLC · Wilmington, DES/N P3370179 N64SFSafe Flight Instrument Corp · White Plains, NYBuilt 1977 · S/N 17268706 N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345 N64TJRcs Farms Inc · Hereford, TXBuilt 1975 · S/N 18264148 N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959 N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665 N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666 N65006Delvalle Enterprises Inc · Sandpoint, IDBuilt 1957 · S/N 34597 N6500ASwartz Walter J · Hadley, MABuilt 1957 · S/N 32397 N6500FMoore Howard W · Camden, TNBuilt 1966 · S/N 15063100 N6500SSpitfire USA Ltd · Rockville, MDBuilt 1967 · S/N 15067300 N6501ERobinson James W · Henderson, NVBuilt 1959 · S/N 56001 N6501FHoward James S · Arlington, TXS/N 15063101 N6501XFisher John P · Surprise, AZBuilt 1960 · S/N 57501 N6501YLively Charters Inc · Summerland Key, FLBuilt 1981 · S/N 21064412 N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670

Back to AD 87-20-03 R2