Skip to content

Registered aircraft · 39,302

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:2000-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01') 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:2000-06-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01')
  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:2000-06-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-06-01')
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.

N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673 N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366 N10505Registration Pending · Effingham, ILRegistration pendingBuilt 1973 · S/N 15074894 N10507Pch Aviation LLC · Elmhurst, ILBuilt 1973 · S/N 15074896 N10509Mckenna Andrew J Sr · Waynesville, OHBuilt 1973 · S/N 15074897 N1050CCourser Ezra D · Columbiaville, MIBuilt 1973 · S/N 15074893 N1050FBuchan John F · Port Ludlow, WABuilt 1975 · S/N 18502707 N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966 N10518Post Ryan · Carmichaels, PAS/N 15074900 N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421 N10524Putrakul Kobkit · London, KYS/N 15074902 N1052FGlb Farms Inc · Pasco, WABuilt 1975 · S/N 18502709 N1052MFendt Alan D Trustee · Dexter, MIBuilt 1975 · S/N 18264216 N10548Scootair LLC · Alburgh, VTBuilt 1973 · S/N 15074908 N1054VNorthington Neill · Fredericksburg, TXBuilt 1976 · S/N R1722094 N10557Parker Helicopter LLC · Watsonville, CABuilt 1973 · S/N 15074909 N1055MRyan Michael W · Long Beach, CABuilt 1975 · S/N 18264217 N1055VWarner Alan P · Carpinteria, CABuilt 1976 · S/N R1722095 N10565Pribyl Cris M · Hennessey, OKS/N 15074912 N10568Buchner Mark L · Springfield, VABuilt 1973 · S/N 15074914 N1056FBrasil John I · Lemon Grove, CABuilt 1975 · S/N 18502712 N10574Osterberg Douglas L · Neenah, WIBuilt 1973 · S/N 15074916 N10577Hatch Arthur S Jr · Mt Vernon, TXBuilt 1973 · S/N 15074917 N1057FBoldflight LLC · Bargersville, INBuilt 1979 · S/N 17272939 N1058MAir Combat Museum · Springfield, ILBuilt 1969 · S/N 15070998 N1058VPelfrey Earl T · Crossville, TNBuilt 1976 · S/N R1722097 N10592Pedrick William M · Dixon, CABuilt 1973 · S/N 15074919 N105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483 N105ASJohnson Scott R · North Hampton, NHBuilt 1973 · S/N 15074786 N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960 N105ESFrederick Sport Flyers Inc · Washington Grove, MDS/N 15079000 N105JKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 17275306 N105MTRegistered aircraftBuilt 1976 · S/N 182-64338 N105NBNorthcentral Aircraft LLC · Blaine, MNBuilt 1984 · S/N 18503732 N105PDN105pd LLC · Ulysses, KSBuilt 1973 · S/N 17261469 N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138 N10604Bittner Vernon J · New Richmond, WIBuilt 1973 · S/N 15074922 N1060FStrausbaugh Paul L · Clifton Forge, VABuilt 1975 · S/N 18502716 N10615Tarr Sheryl L · Spokane Valley, WABuilt 1973 · S/N 15074925 N10617Kern Aviation LLC · Shafter, CABuilt 1973 · S/N 15074927 N10618Roundy Kamlah F · Monteview, IDS/N 15074928 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1061XMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 172-69458 N10621Brosh Cameron R · Loveland, COBuilt 1973 · S/N 15074930 N10628Warner Daniel D · Linden, MIBuilt 1973 · S/N 15074932 N1062FSale Reported · Independence, ORSale reportedBuilt 1975 · S/N 18502718 N10630Perez Juan Carlos · Miami Gardens, FLS/N 15074934

Back to AD 2000-06-01