Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

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 N4526ZArmstrong Brandon M · Sierra Vista, AZBuilt 1961 · S/N 22-8029 N45277Fritz Kurt C · Montoursville, PABuilt 1976 · S/N 177RG1100 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 N4529PAeroclub Management LLC · Cincinnati, OHBuilt 1960 · S/N 27-33 N4529RSulzby Ivan Gerardo · Las Vegas, NVBuilt 1965 · S/N 28-21232 N4529YCunningham David L · Phoenix, AZBuilt 1979 · S/N AA5B1150 N4529ZDaigle Michael R · Andover, NHBuilt 1961 · S/N 22-8032 N452AKSalo Mark W · Poulsbo, WABuilt 1946 · S/N 12-867 N452AMHedges Aviation Inc · Ronkonkoma, NYBuilt 1983 · S/N 40-004 N452CBCyrus Richard W · Salisbury, MDBuilt 2003 · S/N 60409 N452CPCivil Air Patrol · Montgomery, ALBuilt 2013 · S/N 18282368 N452CTMain Rotor Enterprises Llp · Scottsville, KYBuilt 1990 · S/N 1244 N452DMH Grettum LLC · Lewes, DEBuilt 2005 · S/N 3190 N452EPRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11586 N452JPBrushpopper Aviation LLC · Annona, TXBuilt 1991 · S/N 2010

Back to AD 81-18-04 R2