Registered aircraft · 54,017

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.

N5259QFrantz David L · Murfreesboro, TNBuilt 1972 · S/N 15073159 N5259RCarnathan Robert J · Newark, CABuilt 1974 · S/N 17263473 N525AGNoland Ronald E · Weston, ORS/N 51986 N525DBMurtagh Aaron Thomas · RuislipS/N 0484 N525HFVintage Wings Aircraft LLC · Center Point, INBuilt 1977 · S/N 15280442 N525JBWalton Jack R · Granbury, TXBuilt 1979 · S/N 18503907 N525JGFlycarolina LLC · Concord, NCS/N 172RG0178 N525KWFuller Thomas R · Scottsdale, AZBuilt 1975 · S/N 21060881 N525LRSkywalker Leasing LLC · Wilmington, DEBuilt 1980 · S/N 18267356 N525SHMcn Systems LLC · Mount Airy, MDBuilt 1965 · S/N 15062549 N525XHarvey Thomas H · Novi, MIBuilt 1963 · S/N 206-0013 N525ZMMaba Aircraft Services Co · Vero Beach, FLS/N 56760 N52602Hutch Aviation Inc · Zavalla, TXBuilt 1980 · S/N 17274562 N52604Harding Marc S · Des Moines, IABuilt 1977 · S/N 177RG1213 N52607Jse Holdings Inc · Wilmington, DEBuilt 1973 · S/N 18262705 N52608Kaliebe Kyle D · Mount Pleasant, WIBuilt 1973 · S/N 18262706 N5260AN5260a LLC · Los Angeles, CAS/N 21063333 N5260DMeyer Kevin · Hooper, NEBuilt 1979 · S/N 17272478 N5260KPacific Fleet Aviation LLC · Rochester, NYBuilt 1980 · S/N 17274035 N5260NBates Management Inc · Woodstock, GAS/N 18267609 N5260PKaufman Charles · West Palm Beach, FLBuilt 1981 · S/N 15284902 N5260RSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263474 N5260TJordan David E · Saint Helena, CAS/N R18201845 N52612Daniels Willie L II · Castle Pines, COBuilt 1977 · S/N 177RG1215 N52617Land And Sky LLC · Buffalo, MNBuilt 1973 · S/N 18262715 N52619Lardin William A · Thomasville, GABuilt 1977 · S/N 177RG1216 N5261FTopken William F · Fallon, NVS/N 17253375 N5261NCrowe Bradley Allen · North Chelmsford, MABuilt 1980 · S/N 18267610 N5261UBackus Gary Carl · Chesapeake, VABuilt 1980 · S/N 172RG0308 N52620High Risk Ventures Inc · San Diego, CABuilt 1973 · S/N 18262718 N52621Bottieri David P · Mission Viejo, CABuilt 1973 · S/N 18262719 N52624Shrewsbury Roy E II · Daniels, WVBuilt 1973 · S/N 18262721 N52629Mbr Air LLC · Kenosha, WIBuilt 1973 · S/N 18262726 N5262HBun Air Corp · Bedford, PABuilt 1975 · S/N 17265388 N52634Beck Gary F · Cypress, TXBuilt 1977 · S/N 177RG1219 N52635Allard Michael · Penrose, COS/N 17274573 N52636Macdonald Russell K · Richmond Hill, GABuilt 1977 · S/N 177RG1220 N5263QZahn Jason L · Towner, NDBuilt 1965 · S/N 17253380 N5263VMccullough James M · Monte Vista, COBuilt 1975 · S/N 21060883 N52640Crawford Bill E · Hayti, MOBuilt 1977 · S/N 177RG1224 N52643Cardinalrg LLC · Ballwin, MOBuilt 1977 · S/N 177RG1225 N52647Berling David · Litchfield Park, AZBuilt 1977 · S/N 177RG1229 N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725 N5264DPironti Bennett D · Long Valley, NJS/N 17272481 N5264KRmg Aviation LLC · Newark, DEBuilt 1980 · S/N 17274036 N52654Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274576 N5265DFly 172rg LLC · Peoria, AZBuilt 1979 · S/N 17272482 N5265ETree Top Flying Service Inc · Clarksville, TNBuilt 1978 · S/N 17271804 N5265LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284283 N5265QCohan John K · Marina, CABuilt 1972 · S/N 15073165

Back to AD 87-20-03 R2