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.

N9194AWeathered Brenton W · Poquoson, VABuilt 1949 · S/N 18955N9194GJd Business Services LLC · Denair, CAS/N U20603808N91950Bruno Cosimo Gino · Spokane, WABuilt 1969 · S/N 18259966N91954Suchland Simon K · Fairbanks, AKBuilt 1957 · S/N 50105N91958Greenwood Richard S · Duncan, OKBuilt 1969 · S/N 18259967N91963Justpullin Inc · Wilmington, DEBuilt 1969 · S/N 18259970N91966Wings Over Texas Holdings LLC · Denton, TXS/N 17281616N9196BPeterson James G · Keller, TXBuilt 1958 · S/N 36796N9196GJohnson Judith A · Sedro Woolley, WABuilt 1971 · S/N 18260736N9196HLaplante Rene J · Bellingham, WABuilt 1975 · S/N 17266008N9196TC9196tango LLC · Kalispell, MTBuilt 1960 · S/N 50696N9196WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281615N91976Tucker Bobby G · El Dorado, ARBuilt 1969 · S/N 18259975N91978Dvorak Ross E · Highland, CABuilt 1969 · S/N 18259976N9197AAlmeida Gilbert M · Hilmar, CABuilt 1949 · S/N 18958N9197CWood Steven · Morgan, UTBuilt 1954 · S/N 31296N9197GWheeler Dealer LLC · Wilmington, DEBuilt 1971 · S/N 18260737N9197TRichardson Gordon P · Polson, MTBuilt 1960 · S/N 50697N9197UWarfel Everett E · Greenwood, DEBuilt 1976 · S/N 15078148N91984A-Line LLC · Kent, WABuilt 1973 · S/N 17261532N91987Sander William D · Eaton, COBuilt 1969 · S/N 18259982N9198AMorse Steven J · Gig Harbor, WAS/N 18959N9198CSmith Rickey J · Port Saint Joe, FLBuilt 1954 · S/N 31297N9198GDuckflyway LLC · Herscher, ILS/N 18260738N9198WOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281617N91996Oklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281619N91999Gembala Randall L · Kalispell, MTBuilt 1969 · S/N 18259990N9199BM & H Investment LLC · Montgomery City, MOBuilt 1958 · S/N 36799N9199MBlue Sky Flyers Inc · Greeley, COBuilt 1976 · S/N 18264739N9199TFv Arianna Sage Inc · Chignik Lagoon, AKS/N 50699N9199ZOklahoma State University · Stillwater, OKBuilt 2012 · S/N 17281618N919BGuastadisegni Joseph A Trustee · Oak Hills, CABuilt 1970 · S/N 33701307N919CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8339N919DCDelaware Corp · Topping, VABuilt 1976 · S/N 177RG1055N919EHKauffman Keith · Redondo Beach, CABuilt 1959 · S/N 52391N919EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12378N919HWStonehollow Pain Services LLC · Elizabeth, ARS/N 21060054N919RRodriguez Daniel L · West Linn, ORS/N 21059032N919TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 2000 · S/N 17280843N919TCD & S Aviation LLC · Spring, TXBuilt 2005 · S/N 172S10019N919ZATextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13350N91AAShine Donald J · Waterford, WIBuilt 1971 · S/N 33701382N91AZGulf Coast Helicopters Inc · Pearland, TXS/N 18265784N91CCDeep Creek Aviation LLC · Ashburn, GABuilt 1978 · S/N 18266433N91DAJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 18266836N91DJNola Knewbees LLC · New Orleans, LABuilt 1974 · S/N 18262605N91DMHead Joseph A · Fairbanks, AKBuilt 1976 · S/N 18503137N91FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12951N91FSEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280302N91GEGas Aviation LLC · Decatur, TNS/N P3370276
Back to AD 79-10-14 R1