AD 79-10-14 R1

Registered aircraft · 56,582

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.

N6045GWalls Sales LLC · Poplar Bluff, MOBuilt 1969 · S/N 15071545N6045JCavender Michael J · Tucson, AZBuilt 1975 · S/N 18263617N6045TSaladino Michael J · Metairie, LABuilt 1964 · S/N 15060745N60463Angeltown LLC · Covina, CABuilt 1969 · S/N 15070326N6046ADickerson Danny W · York, SCBuilt 1956 · S/N 28646N6046KAl-Rubaiie Haider A · Fort Worth, TXBuilt 1975 · S/N 15077494N6046NPappas Joshua · Wilmette, ILBuilt 1981 · S/N 18504300N6046TDimaio Joseph V · Leesville, LABuilt 1964 · S/N 15060746N60470Lowry John R · Mexico, MOBuilt 1969 · S/N 15070333N60474Koeck Max IV · Metairie, LAS/N 15070337N60475Blair Shawn C · Mandeville, LABuilt 1969 · S/N 15070338N60477Edwards Blake A · Greensburg, KYS/N 15070340N6047AJames Theodore B · Marine St Crx, MNS/N 28647N6047BOliver Ross C Trustee · Eagle River, AKBuilt 1957 · S/N 34047N6047RSwanson Brad J · Yakutat, AKBuilt 1965 · S/N 17253716N60484Erb Charles A · Holden, MEBuilt 1969 · S/N 15070344N60487Mac Mor Ltd · East Troy, WIBuilt 1969 · S/N 15070347N6048GWitthuhn Johnie B · Callaway, NEBuilt 1973 · S/N 18801172TN6048JAll Elements Aviation LLC · Newnan, GABuilt 1972 · S/N A1500348N6048NAero-Mach Labs Inc · Wichita, KSBuilt 1978 · S/N 21062916N6048ZRegistration Pending · Wilmington, DERegistration pendingBuilt 2006 · S/N 172S10217N60492Saint John Harold James · Arvada, COBuilt 1969 · S/N 15070350N60494Heilmann Charli E · Martinsburg, WVBuilt 1969 · S/N 15070352N60499Marion Military Institute · Marion, ALBuilt 1969 · S/N 15070355N6049AMetcalf Nate J · Hooker, OKBuilt 1956 · S/N 28649N6049JKyne James M Jr · Vacaville, CABuilt 1972 · S/N A1500349N6049RSmith Timothy John · Parkville, MDBuilt 1965 · S/N 17253718N604EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12702N604MSHawaiian Airlift Company Llp · Kihei, HIFirst renewal noticeBuilt 1957 · S/N 33985N604NDHeavy Metal Air LLC · Farmingdale, NYBuilt 2012 · S/N 172S11255N604RDSaint Aviation Ministry LLC · Ozark, MOBuilt 1974 · S/N 18052417N604TTUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2008 · S/N 172S10735N60502Janak Jeffrey J · Corpus Christi, TXBuilt 1969 · S/N 15070356N60505Mcbride Kristi L · Lexington, OKBuilt 1969 · S/N 15070359N60509Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1969 · S/N 15070361N6050GNihan Gregory K · Hanson, MABuilt 1969 · S/N 15071550N6050JTri-M LLC · Nikiski, AKS/N 18263619N60510Hansen Larry G · Alliance, NEBuilt 1969 · S/N 15070362N60515Ristevski Bill · Vacaville, CABuilt 1969 · S/N 15070365N6051ABlair Marion J · Lafayette, LABuilt 1956 · S/N 28651N6051BGmr Leasing LLC · Lincoln, DES/N 34051N6051JRobison David · El Dorado, ARBuilt 1972 · S/N A1500351N6051RSpalding David · Ketchum, IDBuilt 1965 · S/N 17253720N6051UVigil Gabriel M · Mora, NMS/N R172-0183N6051VBucelluni Brett · Cypress, TXBuilt 2006 · S/N 172S10245N60522Red Sky Aviation LLC · Livermore, CABuilt 1969 · S/N 15070372N60529My Holdings Inc · Anchorage, AKBuilt 1973 · S/N U20602030N6052APhillips Roberta L · Riverside, CABuilt 1956 · S/N 28652N6052KCollins Robert E · Belleville, ILBuilt 1975 · S/N 15077496N60532Duffy James F · Hudson, WIBuilt 1969 · S/N 15070379
Back to AD 79-10-14 R1