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.

N96928Jurkowski Raymond · Germantown, NYBuilt 1979 · S/N 18266897N96929Ware Joseph B · Angleton, TXBuilt 1979 · S/N 18266898N9692BAberdeen Flying Service · Aberdeen, SDBuilt 1981 · S/N 172RG0971N9692THarbaugh Eric M · Russell, KSS/N 57492N9692VShow Low Flight Academy LLC · Show Low, AZBuilt 1977 · S/N R1722347N9692YA Viation Inc · Bennettsville, SCS/N 21064574N96932Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 17276136N9693HClear Creek Aviation LLC · Buffalo, WYBuilt 1975 · S/N 17266318N9693QHughes Ronnie D · Cedar Park, TXBuilt 1975 · S/N 17265777N9693VRabideau William J III · Stafford Springs, CTBuilt 1974 · S/N 17264472N96943Porta Michael W · Old Bridge, NJBuilt 1979 · S/N 18266904N96949Pittman William Greg · Anchorage, AKBuilt 1979 · S/N 18266908N9694AOgilvie Adam P · Loveland, COBuilt 1950 · S/N 15415N9694HFitch William R · Dubuque, IABuilt 1975 · S/N 17266319N9694LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276598N9694QBexbach North America LLC · Reno, NVBuilt 1975 · S/N 17265778N9694TGarza Gilberto · Yuma, AZS/N 57494N9694VHaller Patrick C · York, SCBuilt 1974 · S/N 17264473N9694XDawson Timothy E · Dahlonega, GAS/N 21057994N96952Gospel Ministries International · Collegedale, TNBuilt 1979 · S/N 18266909N9695HGoddard Robert J · Haverhill, MABuilt 1975 · S/N 17266320N9695XHam Robert · El Cajon, CABuilt 1962 · S/N 21057995N96968Shaw Stephen A · Sherwood, ORBuilt 1979 · S/N 18266918N9696FShakman Michael L Trustee · Chicago, ILBuilt 1998 · S/N 18280269N9696HMirror Image Inc · Belgrade, MTBuilt 1975 · S/N 17266321N9696LAny Border LLC · Yankton, SDBuilt 1986 · S/N 17276599N9696TJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1960 · S/N 57496N96977Couch Christopher · Huntertown, INBuilt 1979 · S/N 18266921N9697QCaltagirone Peter J · Lewes, DEBuilt 1979 · S/N 18503788N9697VWestern Edge Aviation LLC · Dickinson, NDBuilt 1974 · S/N 17264476N96988Wenner Aaron · Tehachapi, CABuilt 1979 · S/N 18266925N9698EPark Rapids Avionics Inc · Park Rapids, MNBuilt 1984 · S/N 18268438N9698GCash Jeffery Scott · Gresham, ORBuilt 1977 · S/N U20603826N9698HEagle Simulator LLC · Lake Oswego, ORBuilt 1975 · S/N 17266322N9698VVermont Flight Academy Inc · South Burlington, VTBuilt 1974 · S/N 17264477N96991Johnson Kirk · Klamath Falls, ORBuilt 1979 · S/N 18266928N9699GCruikshank Brian S · Portland, ORBuilt 1974 · S/N 18263434N9699HDamschroder Rex A · Fremont, OHS/N 337-0395N9699TBas Part Sales LLC · Greeley, COS/N 57499N9699VPiercy Danille Marie · North Bay Village, FLBuilt 1974 · S/N 17264478N969FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10373N969JHJls Aviation LLC DBA · Fredericksburg, VABuilt 1979 · S/N 17273547N969KMSk Aircraft LLC · Anchorage, AKBuilt 1961 · S/N 185-0024N969LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12039N969RBK Fortner LLC · San Marcos, TXBuilt 1968 · S/N U206-1061N969RM182 LLC · Battle Ground, WABuilt 1974 · S/N 18263050N969RRDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275850N969SBBostyancic Stanley J · Cohasset, MNBuilt 1975 · S/N U20602724N969SLWojcik Bart C · Kimberly, IDBuilt 1975 · S/N 21060915N969SPB R S Leasing Inc · Wilmington, DEBuilt 1999 · S/N 172S8171
Back to AD 79-10-14 R1