OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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
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.

N4021JSharapan Ilya · Brooklyn, NYBuilt 1966 · S/N 15065321N4021VBeishline Daniel · Bath, MES/N 18340N4022WAero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10131N4022YKelley Kitty K · Albion, IDBuilt 1961 · S/N 185-0222N4023JHector Flyers LLC · Hector, MNBuilt 1966 · S/N 15065323N4024YJr Aviation LLC · Temple, TXS/N 1850224N4025FBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1958 · S/N 36925N4025URichardson Richard A · Fort Worth, TXBuilt 1965 · S/N 15061425N4026VLandry Timothy G · Lodi, CABuilt 1948 · S/N 18345N4026YOlsen Scott M · Forest Lake, MNBuilt 1961 · S/N 185-0226N4027JMcburney James H Jr · Horseshoe Bay, TXBuilt 1967 · S/N 15065327N4027UTsukii Toshikazu · Tucson, AZBuilt 1965 · S/N 15061427N4028DDriebergen John A · Meridian, IDS/N 34728N4028JWarn James D Jr · Overland Park, KSBuilt 1966 · S/N 15065328N4028UCesperalle Aviation LLC · Grassy Butte, NDS/N 15061428N4029FMcelhaney Jung R · Phelan, CABuilt 1958 · S/N 36929N4029UPathfinder Aero Services LLC · Sheridan, WYS/N 15061429N402CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13235N402CVCivil Air Patrol · Maxell Afb, ALBuilt 2016 · S/N 18282442N402DJFlying Mermaid LLC · Aiea, HIS/N 172S9290N402ERLeighnor Aircraft LLC · Prescott, AZBuilt 1997 · S/N 17280242N402FUSarment David · Ann Arbor, MIBuilt 1973 · S/N 18261534N402MPBravan Aviation Inc · Fort Lauderdale, FLS/N U20606896N402PEDiegos Pet Rescue LLC · Orlando, FLBuilt 1998 · S/N 17280594N4030DPaulson Glenn D · Oro Valley, AZBuilt 1957 · S/N 34730N4031DSurette Phillip · Vail, COBuilt 1957 · S/N 34731N4031YPemberton Addison J · Spokane, WABuilt 1961 · S/N 1850231N4032DPentecost Benjamin · Puyallup, WABuilt 1957 · S/N 34732N4032FDmnm LLC · Albuquerque, NMBuilt 1958 · S/N 36932N4032ULiberty University Inc · Lynchburg, VABuilt 1965 · S/N 15061432N4032VHart Travis R · Ontario, ORBuilt 1948 · S/N 18351N4033DJacquin Aviation Inc · Markham, ILBuilt 1957 · S/N 34733N4033VJepsen James Scott · Kirkwood, MOBuilt 1948 · S/N 18380N4034JStange Robert C · Toledo, OHBuilt 1966 · S/N 15065334N4035DWylie Joshua H · Landgrove, VTBuilt 1957 · S/N 34735N4035FGinn Ray Jr · Beeville, TXBuilt 1958 · S/N 36935N4035JBloomquist Steven R · Granbury, TXS/N 15065335N4035VBeckner Russell R · Rutland, MAS/N 18382N4036DWilson Kevin B P · La Mesa, CABuilt 1957 · S/N 34736N4037FSicaras Paul G · Longmont, COBuilt 1958 · S/N 36937N4037UDelgado Brandon · Moreno Valley, CABuilt 1965 · S/N 15061437N4037YVfr Ltd · Wilmington, DES/N 1850237N4038DSkydive Snohomish Inc · Snohomish, WAS/N 34738N4038FKcantarano LLC · Mukilteo, WABuilt 1958 · S/N 36938N4038VStirling Nathan L · Alton, MEBuilt 1975 · S/N 15076682N4039DKruger Daniel G · Stateline, NVBuilt 1957 · S/N 34739N4039FBlue Ice Aviation Inc · Wasilla, AKS/N 36939N4039UHendrickson Flying Service Inc · Rochelle, ILBuilt 1965 · S/N 15061439N4039VHowe Shawn E · Lewistown, PABuilt 1948 · S/N 18358N403ABItalio River Adventures LLC · Yakutat, AKBuilt 1966 · S/N 18257439
Back to AD 79-10-14 R1