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.

N17033Browning Brad T · Lake Park, MNBuilt 1972 · S/N 150-73594N17039Davidson Luke H · Gilmer, TXS/N 15073597N1703NEvans Richard H Sr · Holt, FLFirst renewal noticeS/N 11947N1703QTroutman Noah M · Owensboro, KYBuilt 1971 · S/N 15073003N17043Coleman Sherod · Houston, TXBuilt 1972 · S/N 15073600N17045Streichenwein Scott F · Salisbury Mills, NYBuilt 1972 · S/N 15073602N17047Sickinger Alan W · New Philadelphia, OHBuilt 1972 · S/N 15073604N17048Myob Group LLC · Ocala, FLBuilt 1972 · S/N 15073605N1704DSykes Gregory P · Arlington, WABuilt 1951 · S/N 20147N17053Rough Joseph W · Priest Lake, IDBuilt 1953 · S/N 25678N1705DSchultz Jeffrey J · Wasilla, AKBuilt 1951 · S/N 20148N1705FTennis Gayland L · Bath, MIBuilt 1966 · S/N 17255100N17060Jacobsen Lee E · Inchelium, WABuilt 1972 · S/N 15073612N17065Glaser Donald L Jr · Olive Branch, MSS/N 150-73615N17069Joyce Michael P · New Kent, VAS/N 15073619N1706DMaser Matt P · Junction City, ORBuilt 1952 · S/N 20149N1706VHermann Christine F · Radford, VABuilt 1947 · S/N 13891N17077Shehl George William III · Charleston, WVBuilt 1972 · S/N 15073257N1707DMorse David M · Kernersville, NCBuilt 1951 · S/N 20150N1707FFreije Anthony M · Anchorage, AKBuilt 1966 · S/N 17255102N1707QGarcia Jorge A · Ponce, PRBuilt 1971 · S/N 15073007N1708FKnudsen Mark A · Whitmore Lake, MIBuilt 1966 · S/N 17255103N1708QJergovich Jack A · Austin, TXBuilt 1971 · S/N 15073008N1708UShelton Philip C · Wise, VABuilt 1947 · S/N 12160N1708VMock Paul M · Williams, AZBuilt 1947 · S/N 13893N17098Lake Michigan Asset Management LLC · Grand Rapids, MIBuilt 1972 · S/N 15073622N170AGHuber David C · Victoria, TXBuilt 1949 · S/N 18975N170AKPerry John E · Kenai, AKBuilt 1953 · S/N 25431N170ARSmith Edward T · Bradenton, FLBuilt 1952 · S/N 20604N170ASBowe Rick J Trustee · Chippewa Falls, WIBuilt 1950 · S/N 19824N170ATVan Anda Aviation LLC · Apopka, FLBuilt 1966 · S/N 17254850N170BRegistered aircraftBuilt 1952 · S/N 20944N170BBSmothers Joey D · Dwight, ILS/N 26297N170BGFinley Rory P · Loon Lake, WABuilt 1952 · S/N 25392N170BKDugan Robert J · Boulder City, NVBuilt 1952 · S/N 20839N170BSMcintyre James C · Bethlehem, PABuilt 1954 · S/N 26214N170BTSparks Richard M · Wasilla, AKBuilt 1954 · S/N 26162N170CFAbes Erika · El Paso, TXBuilt 1953 · S/N 25904N170CLHickle William H · Inyokern, CABuilt 1952 · S/N 20699N170CPLawrence Wyatt · White House, TNBuilt 1955 · S/N 26986N170CWHohmann Courtney P · Jacksonville, FLBuilt 1952 · S/N 20411N170DFWilliams John S · Cleveland, TXBuilt 1950 · S/N 19519N170DMBarnstorm/T-34 LLC · Jacksonville, FLBuilt 1952 · S/N 20803N170DPLeingang Mark J · Olympia, WABuilt 1955 · S/N 26716N170DWBelden George B · Sonoma, CABuilt 1949 · S/N 19154N170ECMueller Brent · Saint Maries, IDBuilt 1952 · S/N 20800N170EEDowd Darin R · Gainesville, TXBuilt 1948 · S/N 18063N170ERBowles Brent J · Iraan, TXBuilt 1948 · S/N 18328N170ETPalmatier Harry C III · Volant, PAS/N 19641N170FMMain Freddie L II · Trophy Club, TXBuilt 1957 · S/N 25246
Back to AD 94-05-05 R1