Skip to content

Registered aircraft · 54,016

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-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N1054DBrown Douglas R · Centralia, WABuilt 1951 · S/N 7666 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 N1056DSmooth Landings LLC · Magee, MSBuilt 1951 · S/N 7668 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 N1057DMedore Douglas A · Romoland, CAS/N 7669 N1057FBoldflight LLC · Bargersville, INBuilt 1979 · S/N 17272939 N1058DMorley Philip · Manhattan Beach, CABuilt 1951 · S/N 7670 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 N1059RDoyle Brian G · Windsor, MABuilt 1958 · S/N 55629 N105AAWehrmacher James P · Crawford, COBuilt 1978 · S/N R18200483 N105ASJohnson Scott R · North Hampton, NHBuilt 1973 · S/N 15074786 N105DFWestwood Aero Inc · Porterville, CABuilt 1986 · S/N 21064999 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 N10644American Flag Airlines Inc · Ft Lauderdale, FLBuilt 1973 · S/N 15074942 N10645Dearborn Edward M · Acworth, GAS/N 15074943 N10647Kosko Stanley G · Seattle, WAS/N 15074945 N10649Seaplane Adventures LLC · Cheyenne, WYS/N 15074947 N1064VHenderson Robert J · Grass Lake, MIBuilt 1977 · S/N R1722099 N10651Wampler Matthew T · Valles Mines, MOBuilt 1973 · S/N 15074948 N10653Loftin Jamie B · Shreveport, LABuilt 1973 · S/N 15074950 N10658Craigmyle William R · Cooperstown, NYBuilt 1973 · S/N 15074952

Back to AD 87-20-03 R2