Skip to content

Registered aircraft · 40,396

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.

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 N4525L525 Lima Corp · Grayslake, ILBuilt 1979 · S/N AA5B1119 N4525NClavey Sean P · Port Orange, FLBuilt 1979 · S/N AA5B1120 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 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 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 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 N4528GBokoskie Isaac J · Kearney, NEBuilt 2009 · S/N 001 N4528NPayne Craig Andrew · Discovery Bay, CABuilt 1979 · S/N AA5B1141 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 N4529RSulzby Ivan Gerardo · Las Vegas, NVBuilt 1965 · S/N 28-21232 N4529YCunningham David L · Phoenix, AZBuilt 1979 · S/N AA5B1150 N452AKSalo Mark W · Poulsbo, WABuilt 1946 · S/N 12-867 N452CBCyrus Richard W · Salisbury, MDBuilt 2003 · S/N 60409 N45304Unruh Gerald R · Nampa, IDBuilt 1979 · S/N AA5B1158 N4530DMccauley Terry D · Rogers, ARBuilt 1979 · S/N AA5B1153 N4530EAig Aeronautics LLC · San Juan, PRBuilt 1978 · S/N 17271621 N4530SMontague Ronnie L · French Camp, MSS/N AA5B1156 N4530TKoprivnik Anton J · Painesville, OHS/N 287225181 N4530VSaunders Christopher D · Lehighton, PABuilt 1948 · S/N D-1356SV-106 N45315Taylor Caleb H Trustee · Rancho Santa Fe, CABuilt 1979 · S/N AA5B1167 N45319Dale Timothy · Simsbury, CTBuilt 1979 · S/N AA5B1168 N4531SMajors Flying Club · Greenville, TXBuilt 1979 · S/N AA5B1164 N4531ZFelts Jacob I · Kalispell, MTBuilt 1960 · S/N 22-8036 N45322Alvord Scott Richard · Yorba Linda, CABuilt 1979 · S/N AA5B1180 N4532ARasmussen Duane T · Culbertson, MTBuilt 1956 · S/N 22-3841

Back to AD 79-10-03 R2