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.

N65192Tactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 1982 · S/N 17275706N65195Sciortino Warren A III · Crested Butte, COBuilt 1966 · S/N R1720021N65197Aviator Education LLC · Greeley, COBuilt 1972 · S/N 17275707N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542N6519JDms Defense LLC · Annapolis, MDBuilt 1980 · S/N 17273882N6519MWarar Manjit S · Shreveport, LABuilt 1975 · S/N 18263736N6519XN5746u LLC · Dover, DEBuilt 1960 · S/N 57519N651DRCreative Art And Design LLC · Arvada, COBuilt 1955 · S/N 31369N651ECEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700633N651EFGrizzly Air LLC · Clearwater, FLBuilt 1967 · S/N 15067317N651EREmbry-Riddle Aernautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13085N651MAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 2000 · S/N 17280897N651PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12016N651SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606996N65206Brinkhoff Gary H · Hygiene, COBuilt 1964 · S/N P206-0024N6520ENichols Matthew Q · Maple Valley, WABuilt 1959 · S/N 56020N6520SHighfield Carey · Vanceburg, KYBuilt 1967 · S/N 15067320N6520XKenton Onstad · Parshall, NDBuilt 1960 · S/N 57520N652171434 Jpl LLC · Wilmington, DEBuilt 2004 · S/N 18281415N6521AWiplinger Robert D · Inver Grove, MNBuilt 1956 · S/N 32418N6521DWaade Odd · Bellingham, WABuilt 1979 · S/N 17272842N6521EWeaver Clifford A · East Berlin, PABuilt 1959 · S/N 56021N6521GKirk James H III · Odessa, FLBuilt 1970 · S/N 15072021N6521XNelson Scott W · Summerset, SDBuilt 1960 · S/N 57521N65221Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275711N65225Leon Manuel Perez · Lake Worth, FLBuilt 2004 · S/N 18281414N6522AHubbard Robert L · Anchorage, AKBuilt 1956 · S/N 32419N6522RKnot Ventures LLC · Kalispell, MTBuilt 1979 · S/N 172RG0191N6522SAlicandro Mark B · Sebastian, FLBuilt 1967 · S/N 15067322N65236Taylor Jonathan P · Danbury, CTBuilt 2004 · S/N 18281417N6523DAir Shares LLC · Casper, WYBuilt 1979 · S/N 17272844N6523ESkeen Andrew · Lindon, UTBuilt 1959 · S/N 56023N6523FMatthews Mark · Brandon, MSBuilt 1966 · S/N 15063123N6523GLee Jay S · Granite Bay, CABuilt 1970 · S/N 15072023N6523TVan Bavel Ethan G · Soldotna, AKBuilt 1967 · S/N 18051899N6523VReal Jonathan D · Kamuela, HIBuilt 1980 · S/N 172RG0749N6524DZuckerman Zvi A · Boardman, OHBuilt 1979 · S/N 17272845N6524EWhite Wings LLC · Anchorage, AKBuilt 1959 · S/N 56024N6524GSantana Eric · Lehigh Acres, FLS/N 15072024N6524HCole Keith D Trustee · Celina, TXBuilt 1975 · S/N 17265474N6524NWolcott Terri · Salem, ORBuilt 1981 · S/N 18267835N6524TParks Sam E Jr · Lytle, TXBuilt 1960 · S/N 17924N652515280 Flying Club LLC · Castle Pines, COBuilt 2004 · S/N 172S9690N65259Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1982 · S/N 17275715N6525DAerospace Testing Engineering & Certification Inc · Seattle, WABuilt 1979 · S/N 17272846N6525MStene Nathanial S · Waterloo, NES/N 18263739N6526FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15063126N6526MDapp Eric M · Corvallis, ORBuilt 1977 · S/N 21061973N6526THilt Destin R · Auburn, CABuilt 1960 · S/N 17926N6526VGoodrow Anthony F · Creede, COBuilt 1980 · S/N 172RG0752
Back to AD 79-10-14 R1