Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N45249Porus Joseph B · Oakland, NJBuilt 1979 · S/N AA5B1115 N4524BBarbero Matias J · Cape Coral, FLBuilt 1979 · S/N AA5B1098 N4524EHarper Michael B · Buena Vista, COBuilt 1979 · S/N AA5B1099 N4524KMorris David R · Montara, CABuilt 1979 · S/N AA5B1100 N4524NHorejsi Michael E · Castro Valley, CABuilt 1979 · S/N AA5B1103 N4524PRegistered aircraftBuilt 1979 · S/N AA5B1105 N4524QRegistered aircraftBuilt 1979 · S/N AA5B1106 N4524WRichardson Shane D · Pekin, ILBuilt 1979 · S/N AA5B1109 N4524XSharp Jacob · El Paso, TXBuilt 1975 · S/N 28R-7635069 N4524ZMercer Eric S · Ukiah, CABuilt 1979 · S/N AA5B1111 N45253Dewey Alice · West Palm Beach, FLBuilt 1979 · S/N AA5B1126 N4525BCmis N4525b LLC · Carlsbad, CABuilt 1979 · S/N AA5B1116 N4525CBeauchard Lucine E · Morehead City, NCBuilt 1979 · S/N AA5B1117 N4525FStallknecht William A · San Antonio, TXBuilt 1979 · S/N AA5B1118 N4525GMcdonald James O · Hulett, WYBuilt 2008 · S/N WYOI N4525L525 Lima Corp · Grayslake, ILBuilt 1979 · S/N AA5B1119 N4525NClavey Sean P · Port Orange, FLBuilt 1979 · S/N AA5B1120 N4525PFlying L Aircraft Inc · Fort Denaud, FLBuilt 1960 · S/N 27-29 N4525RFreiberg Industries Inc · State Center, IAFirst renewal noticeBuilt 1965 · S/N 28-21228 N4525UBenedict Co LLC · Maryville, TNBuilt 1979 · S/N AA5B1122 N4525WHamilton Kevin Michael · Lake Charles, LABuilt 1979 · S/N AA5B1123 N4525YGorham James A · Mandan, NDBuilt 1979 · S/N AA5B1124 N4525ZPadilla Jesse · Fremont, CABuilt 1979 · S/N AA5B-1125 N4526AMathews William A · Albuquerque, NMBuilt 1956 · S/N 22-3834 N4526BMorris Scott W · Livermore, CABuilt 1979 · S/N AA5B1127 N4526FReabe Spraying Service Inc · Plover, WIBuilt 1976 · S/N 28-7790040 N4526JMcallister Aviation LLC · Richmond Hill, GABuilt 1968 · S/N 28R-30384 N4526LHeider Timothy Robert · Portland, ORS/N AA5B1129 N4526NButler Milton Forest · Oxford, GABuilt 1979 · S/N AA5B1130 N4526RGulledge Richard · Deland, FLBuilt 1965 · S/N 28-21229 N4526TBoal Ronald O · Mooresburg, TNBuilt 1972 · S/N 28R-7235078 N4526XGeorge Barbara A · Carlisle, PABuilt 1975 · S/N 28-7625049 N45278Becker Air LLC · Stratford, CTBuilt 1979 · S/N AA5B1138 N4527AMacking Craig P · Sepulveda, CABuilt 1956 · S/N 22-3835 N4527JRegistration Pending · Cedar Hill, TXRegistration pendingS/N 28R-30385 N4527LSchramm Harold · Utica, SDBuilt 1979 · S/N AA5B1133 N4527NTobin Dwight B · New York, NYBuilt 1979 · S/N AA5B1134 N4527RGmk Aviation LLC · Brighton, MIBuilt 1965 · S/N 28-21230 N45286Isley Phillip A · Anchorage, AKBuilt 1979 · S/N AA5B1143 N4528FPhoenix Aviation Solutions LLC · Clarksville, TNBuilt 1976 · S/N 28R-7635414 N4528GBokoskie Isaac J · Kearney, NEBuilt 2009 · S/N 001 N4528NPayne Craig Andrew · Discovery Bay, CABuilt 1979 · S/N AA5B1141 N4528PCartagena Carlos A · Sierra Vista, AZBuilt 1960 · S/N 27-32 N4528RPhilbrick William E · Virginia Beach, VABuilt 1965 · S/N 28-21231 N4528XChandler Agricultural Ind LLC Series Avation · Montgomery, ALBuilt 1975 · S/N 28-7690030 N4529ACoffey County Airport · Burlington, KSBuilt 1956 · S/N 22-3838 N4529BCianfaglione Peter W · Madison, ALBuilt 1979 · S/N AA5B1144 N4529DMakowiecki Maciej Piotr · Woodland Hills, CABuilt 1979 · S/N AA5B1145 N4529LHopkins Josh · Corpus Christi, TXS/N AA5B1147 N4529NJames Douglas Z · Coudersport, PABuilt 1979 · S/N AA5B1148

Back to AD 87-10-06 R1