AD 94-05-05 R1

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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.

N180HPorter Jeff S · Aguila, AZBuilt 1951 · S/N 19944N180HPRobinson Michael D · Folkston, GABuilt 1959 · S/N 17381N18100Liberty University School Of Aeronautics · Lynchburg, VABuilt 1972 · S/N 15073785N18104Toth Stephen K · Northampton, PABuilt 1972 · S/N 15073788N18108Larsen Kevin L · Firth, IDBuilt 1948 · S/N 18108N18109Szoke Elliott · Mukilteo, WAS/N 15073792N1810NMetzler Darwin H · Manheim, PABuilt 1946 · S/N 12054N1810YLussier Lisa · Greene, RIFirst renewal noticeBuilt 1962 · S/N 17249410N18110Radke Steven H · Hastings, MNBuilt 1972 · S/N 15073793N18115Hinds Community College · Raymond, MSBuilt 1972 · S/N 15073796N1811CEastburn Maurice H · Peyton, COBuilt 1953 · S/N 25955N1811EEndres Sam D · Gainesville, TXBuilt 1946 · S/N 7AC-5378N18126Harroun Charles G · Maryville, MOBuilt 1972 · S/N 15073804N1812KMichaelsen Mark R · Leesburg, VABuilt 1946 · S/N 4539N1812NRutherford Kevin · Sheridan, ARBuilt 1946 · S/N 12056N1812YHopkins Mark W · Emporia, KSBuilt 1962 · S/N 17249412N1813KWilliams Jay P · Moses Lake, WABuilt 1946 · S/N 4540N1813VCodingflyboy LLC · Hayward, CAS/N 13998N18140Johnroe Ryan M · Mount Pleasant, MIBuilt 1972 · S/N 15073815N18144Kachemak Bay Flying Service · Temple, TXBuilt 1972 · S/N 15073817N18145Stlouis Aviation LLC · Miramar, FLBuilt 1972 · S/N 15073818N18155Willis Nathan Eric · Broken Arrow, OKBuilt 1972 · S/N 15073828N18157Matz Robert D · Niles, MIBuilt 1972 · S/N 15073830N1815BHaugen Michael C · Oklahoma City, OKBuilt 1948 · S/N 6242N18162Pruzek Richard L · Chippewa Falls, WIBuilt 1972 · S/N 15073834N18163Wings Aero LLC · Zeeland, MIBuilt 1972 · S/N 15073835N18164Cendejas Agustin · Chino, CABuilt 1972 · S/N 15073836N18167Be Chara Niz Ar E · Columbia, MDBuilt 1972 · S/N 15073838N1816BBuchanan Karen K · North Hampton, NHS/N 6246N1816CCalvert Tobin R · San Antonio, TXBuilt 1953 · S/N 25960N1816KCartledge Douglas J · Seville, OHS/N 4543N1816YNicholas Thomas M II · Enid, OKBuilt 1962 · S/N 17249416N18171Isaacson Arthur T · Hillsboro, MOS/N 15073840N18173Bb Aero Works Ltd · Whitehouse, OHBuilt 1972 · S/N 15073842N18177Hoffman Rick W · Elk River, MNBuilt 1972 · S/N 15073846N1817BSlack Jonathan D · Bonfield, ILBuilt 1948 · S/N 6244N1817VHarper James J · Miller, MOBuilt 1947 · S/N 14002N18180Woodward Aviation · Varnville, SCS/N 15073847N1818BWilliams Timothy W · West Monroe, LABuilt 1948 · S/N 6245N1818NFirth Thomas H IV · Sonora, CABuilt 1946 · S/N 12062N18197C150 Holdings LLC · Newark, DEBuilt 1972 · S/N 15073854N18198Ohare Douglas K · Ainsworth, NEBuilt 1972 · S/N 15073855N18199Forthman Scott Chance · Miami, FLBuilt 1972 · S/N 15073856N1819CFischer Douglas J · Palermo, CAS/N 25963N1819NPower Terry Edward · Council, IDBuilt 1946 · S/N 12063N1819VSparebanc LLC · Appleton, MNBuilt 1947 · S/N 14004N181HRevoir Scott R · Hastings, NYBuilt 1968 · S/N 4N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385N181VVScriva Jennifer L · Sherwood, ARBuilt 1966 · S/N 15065010N18200Morristown Flying Service Inc · Talbott, TNBuilt 1972 · S/N 15073857
Back to AD 94-05-05 R1