Skip to content

Registered aircraft · 56,572

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

N105HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8724 N105JKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 17275306 N105JMBullard Roy P · Granbury, TXBuilt 2006 · S/N 18281743 N105LULynn University · Boca Raton, FLBuilt 2005 · S/N 172S9774 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 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 N10624Daytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9825 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 N10632Skyblue Aviation Cr Inc · Merritt Island, FLBuilt 2007 · S/N 17281431 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 N1065UKloker Daniel E · Owasso, OKS/N 18281573 N1065VRegistered aircraftBuilt 1974 · S/N U20602435 N10661Colberg Sigurd E · Palmer, AKBuilt 1973 · S/N 15074955 N10662Momin Ahmed H · Sugar Land, TXBuilt 2005 · S/N 18281577 N10663General Aircraft Services LLC · Pendleton, ORS/N 15074957 N10669Loeppky Neal K · Seminole, TXBuilt 1973 · S/N 15074962 N10679Samson Rene R · Lewiston, MES/N 15074968 N1067LCollins Gene William · Manassas, VABuilt 1973 · S/N 15074965 N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367 N10681Chickasha Wings Inc · Chickasha, OKBuilt 1973 · S/N 15074970 N10682Thomas Edward L · West Bend, WIBuilt 1973 · S/N 15074971 N10683Burton Ryne W · Astoria, ILBuilt 1973 · S/N 15074972 N10687Boatright William L · Colonial Beach, VABuilt 1973 · S/N 15074974 N10688Wilson Oscar O Jr · Kountze, TXBuilt 1973 · S/N 15074975 N10689Jansen Sarah · Pingree Grove, ILBuilt 1973 · S/N 15074976 N1068FDubois Marcus S · Olive Branch, MSBuilt 1979 · S/N 17272943 N1068MWolfenden Allen K · Rocklin, CABuilt 1971 · S/N 17259988 N10693Full Stop Aviation LLC · Union City, TNBuilt 1973 · S/N 15074978 N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633

Back to AD 79-10-14 R1