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.

N5534KAerolife Aviation LLC · Knox, INBuilt 1978 · S/N 1028-78 N5535FTrent Donald R · Rustburg, VABuilt 1968 · S/N 28-24934 N5535MButz Jonathan O · Mansfield, OHBuilt 1967 · S/N 121 N5535QJohnson Bar Inc · Pensacola, FLBuilt 1965 · S/N 2956 N55364Cremel Roberto J · Trumbull, CTS/N 28-7325384 N5536EJeffries And Hendley LLC · Greenwood, INBuilt 1978 · S/N 17271885 N5536FArnt James R Jr · Worthington, MNBuilt 1968 · S/N 28-24935 N5536PGryhon Designs · Camden, SCBuilt 1958 · S/N 24-600 N5536UPittman Discover Flight LLC · Oshkosh, WIBuilt 1969 · S/N 28-26257 N5536WSchilke Kenneth · Imperial, NES/N 28-626 N55372Mccarroll Daniel C · Saint Augustine, FLS/N 1188 N55374American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275170 N5537MWiglesworth David G · Lenexa, KSBuilt 1967 · S/N 123 N5537PField Gerard · Middleboro, MABuilt 1958 · S/N 24-601 N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073 N55380Clark Joseph David · Kilgore, TXS/N 28-7325388 N55383Winkelman James R · Zionsville, INBuilt 1973 · S/N 28-7305371 N55386Redlands Flying Club · Redlands, CAS/N 1189 N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944 N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78 N5538UAircraft Sales LLC · Caledonia, MIBuilt 1969 · S/N 28-26260 N55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325391 N55397Stephens Ryan L · Gardner, ILBuilt 1973 · S/N 28-7305374 N55398Three Wire LLC · Portland, ORBuilt 1981 · S/N 17275174 N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945 N5539FAeronautical Technical Service Inc · Collierville, TNBuilt 1968 · S/N 28-24938 N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958 N5539UDickey Blaine K · Marion, ARBuilt 1969 · S/N 28-26261 N553APAviation Paradise LLC · Homestead, FLBuilt 1980 · S/N 17274554 N553BCCarlson Robert A · Red Wing, MNBuilt 2001 · S/N 2171 N553FLWalters Rande L Sr · Lock Haven, PABuilt 1971 · S/N 28-7125392 N553MBBickling Melvin T · Johnstown, COBuilt 2011 · S/N 91457 N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072 N553PGAnderson Adam Z · Bay City, MIBuilt 2005 · S/N 2318 N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090 N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247 N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105 N55401Keesling Roger · Starkville, MSBuilt 1973 · S/N 28-7325405 N55402Gleason Scot · Hayden, IDBuilt 1973 · S/N 28-7325395 N55404Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17275175 N55407Yeager Bradley William · New Market, ALBuilt 1973 · S/N 28-7305377 N5540UEvans Thomas Patrick · Hollow Rock, TNBuilt 1969 · S/N 28-26262 N5540WAir-Crete Constructions Inc · Lake Elmo, MNBuilt 1962 · S/N 28-631 N55416Cox David S · Elizabethtown, KYBuilt 1973 · S/N 28-7325397 N55419Kinneberg Russell · Plymouth, MNBuilt 1973 · S/N 28-7305380 N5541MDistrict School Board Of Pasco County · Land O Lakes, FLFirst renewal noticeBuilt 1967 · S/N 127 N5541URegistered aircraftS/N 28-26263 N5541WKauffman Duane N · Sarasota, FLBuilt 1962 · S/N 28-632 N55420M A R S Aircraft Leasing LLC · Williamsburg, VABuilt 1981 · S/N 17275177 N55421Burton Tucker · Moberly, MOBuilt 1973 · S/N 28-7305381

Back to AD 80-04-03 R2