Skip to content

Registered aircraft · 22,432

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N15744West Kentucky Flyers Corp · Murray, KYBuilt 1972 · S/N 28R-7335086 N1574XQuinones Roland · Plano, TXS/N 28R-7535338 N15753Bischoff Daniel C · Camano Island, WABuilt 1972 · S/N 28-7325152 N15755Fitzgerald Lee M · High Springs, FLBuilt 1973 · S/N 28-7325154 N15757Dickinson Ross · Tilden, TXBuilt 1972 · S/N 28-7305137 N15759Williams Sean Aaron · Whiteland, INBuilt 1973 · S/N 28-7325155 N1575XMaring Thomas J · Westley, CABuilt 1975 · S/N 32-7540178 N15760Been Flyin LLC · Colchester, CTBuilt 1972 · S/N 28-7325157 N15762Carlevaro Bruce C · Edmond, OKBuilt 1972 · S/N 28-7305140 N15763First Pryority Bank · Pryor, OKBuilt 1972 · S/N 28-7305141 N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089 N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090 N15768Khleb Hub LLC · Palm Coast, FLBuilt 1973 · S/N 28-7325156 N1576JInspire Aviation LLC · Magnolia, TXBuilt 1967 · S/N 28-23982 N15770Collett Palmer · Frankfort, KYBuilt 1972 · S/N 28-7325159 N15776Rc & C Inc · Norwalk, IABuilt 1972 · S/N 32-7340064 N15782Crane Austin · Redlands, CAS/N 28-7305144 N15783Pretorius Anthony · Easley, SCBuilt 1972 · S/N 28-7305145 N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016 N1579JTornow Saxon Michael · Highland, UTS/N 28-23987 N1579XBuchberger Robert J · Plainfield, WIBuilt 1975 · S/N 28-7510111 N157ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010053 N157CMChamark LLC · Knoxville, TNBuilt 1975 · S/N 32R-7680023 N157LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842199 N157RJTdt Ag Support LLC · Brawley, CABuilt 1979 · S/N 28-7911168 N157TASpace Coast Aircraft Co · Meritt Island, FLBuilt 1998 · S/N 2842029 N157WAUnited States Air Force - Owner · Hanscom Afb, MABuilt 2019 · S/N 2881157 N15800Somd Aircraft Rentals And Instruction LLC · Leonardtown, MDBuilt 1972 · S/N 28-7325167 N15802Farias Wellington N · Hollis, NHS/N 28-7305146 N15804Lima Juliet LLC · Pearcy, ARBuilt 1972 · S/N 28-7305150 N15807Timmons Nathan M · Sarepta, LABuilt 1972 · S/N 28-7325168 N15808Dudek Henry · Clinton Township, MIBuilt 1972 · S/N 28-7325169 N158124 Bachelors LLC · Chesaning, MIS/N 28-7305152 N15814Alderson Collin · North Bend, NEBuilt 1972 · S/N 28R-7335094 N15819Brewer Les · Magna, UTS/N 28-7325170 N1581JDarling Steven M · Decatur, INS/N 28-23989 N15822Keys Daniel A · Irvine, CABuilt 1972 · S/N 28-7325172 N15824Sale Reported · Angwin, CASale reportedBuilt 1972 · S/N 28-7305156 N15825Jem Machine Inc · Grangeville, IDBuilt 1972 · S/N 28-7305157 N1582XInnovative Aviation LLC · Indiana, PAS/N 28R-7535340 N15832Mickschl Bradley J · Avon, INBuilt 1972 · S/N 28R-7335093 N1583XK&T Lawn & Landscape Inc · Newport News, VABuilt 1975 · S/N 32-7540179 N15842Reynolds Larry J · Rhome, TXBuilt 1972 · S/N 28-7325177 N1584JLake Kenneth M · Manchester, MOBuilt 1967 · S/N 28-23993 N15850Aviation East Inc · Mount Pleasant, SCBuilt 1972 · S/N 28-7305164 N15851Eakle Ivan · Sacramento, CABuilt 1972 · S/N 28-7325190 N15858T T T Inc · Georgetown, PABuilt 1972 · S/N 28-7325180 N1585JAnderson Aviation LLC · Eatonville, WABuilt 1967 · S/N 28-23994 N15860Baker Stephen J · Surprise, AZBuilt 1972 · S/N 28-7305165 N15861Registration Pending · Traverse City, MIRegistration pending, pending cancellationBuilt 1972 · S/N 28-7305167

Back to AD 87-08-08 R3