Skip to content

Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N45223Moran Timothy P · Acworth, GABuilt 1979 · S/N AA5B1088 N45226Gildersleeve Robert · Storrs, CTBuilt 1979 · S/N AA5B1089 N4522ABryant Stephen · Anchorage, AKS/N 22-3829 N4522BKlifman Dustin · Muskegon, MIBuilt 1979 · S/N AA5B1081 N4522LGaines Charles C · Fernandina, FLBuilt 1979 · S/N AA5B1084 N4522NFrieling Judson D · Houston, TXBuilt 1979 · S/N AA5B1085 N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028 N4522ZCandeletti James · Forked River, NJBuilt 1979 · S/N AA5B1087 N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467 N4523DFalk Thomas M · Silver Spring, MDBuilt 1979 · S/N AA5B1091 N4523RGardner Michael J · Ashland, ILS/N 28-21225 N45240Buford Thomas Edwin · Lemoore, CABuilt 1979 · S/N AA5B1112 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 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

Back to AD 80-04-03 R2