OpenAirDocs.org
AD 94-20-04 R1

Registered aircraft · 4,469

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-20-04-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-20-04-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.

N689DShue Robert R Jr · Easley, SCBuilt 1951 · S/N D-2965N689TNunez Manuel · Mcallen, TXS/N D-7408N68APAbecca Corporation · Jackson, MIBuilt 1968 · S/N D-8899N68DLAsap Flying Service Inc · Hermiston, ORS/N D-5118N68JGH & M Aviation · Hazelton, NDBuilt 1957 · S/N D-4977N68SMSimms Richard J · Shady Shores, TXBuilt 1968 · S/N D-8779N68TTStanley Scott C · Winston Salem, NCBuilt 1953 · S/N D-3563N6900VYoungs William D Jr · Moravia, NYBuilt 1957 · S/N D-4955N691QKorthuis Donald · Everson, WABuilt 1959 · S/N D-6111N691RBPali Inc · Nashville, TNBuilt 1967 · S/N D-8639N691VKeilman Geary · Las Vegas, NVBuilt 1960 · S/N D-6430N692QChavez Leroy · Albuquerque, NMBuilt 1959 · S/N D-6112N693TAviators Insurance Agency Inc · Van Nuys, CABuilt 1959 · S/N D-5984N693VArmstrong Blane A · Albuquerque, NMBuilt 1960 · S/N D-6444N694DBas Part Sales LLC · Greeley, COS/N D-2971N695DBurgin Lee · Borger, TXS/N D-2973N696FWorkman Matthew E · Albuquerque, NMBuilt 1952 · S/N D-3332N6999N3v1 LLC · Pensacola, FLBuilt 1975 · S/N D-9815N69CABowers Glenn N · Overland Park, KSBuilt 1954 · S/N D-3754N69FCAmes Ryan P · Oshkosh, WIS/N D-7137N69LJGonzalez-Ceballos Lorena Isabel · Haw River, NCS/N D-9692N69XGHahn Curtis D · Saint George, UTBuilt 1976 · S/N D-9859N6AYTwin Cities Aviation Inc · Yuba City, CABuilt 1966 · S/N D-8344N6FQualitair LLC Trustee · MichelstadtBuilt 1955 · S/N D-4368N6HHHansen Mike D · Spicewood, TXBuilt 1962 · S/N D-6928N6JKMatissek Joseph G · New Port Richey, FLBuilt 1964 · S/N D-7577N6MYPruitt Robert G · Russellville, ARS/N D-8107N6RHDill Steven Vaughn · Lenoir City, TNBuilt 1959 · S/N D-6200N6RMHarper Bryan K · Junction City, ORBuilt 1964 · S/N D7411N6SVFaivre Anthony L · Hampshire, ILBuilt 1969 · S/N D-8917N6THDouble I Flyers Inc · Wilmington, DEBuilt 1974 · S/N D-9622N7000QRegistered aircraftS/N D-7000N7002NBfr Racing Inc · Monticello, ARBuilt 1967 · S/N D-8613N700BTHogan Christopher S · Colorado Springs, COBuilt 1966 · S/N D-8076N700EDMcd Aviation Inc · Wilmington, DEBuilt 1972 · S/N D-9372N7016NN7016n LLC · Columbia, MOBuilt 1967 · S/N D-8649N7018NLawless Van N Jr · Mooresville, NCBuilt 1967 · S/N D-8618N7021NRobertson Eric A · Knoxville, TNBuilt 1967 · S/N D-8620N7023NSteria Kermit J · Monahans, TXBuilt 1967 · S/N D-8627N703THall Charles M · Lubbock, TXBuilt 1975 · S/N D-9816N7045NIndy Air Sales LLC · Anderson, INBuilt 1967 · S/N D-8633N7046NMoore John Robert III · Lusby, MDBuilt 1967 · S/N D-8634N7048NBonanza Enterprises LLC · Mill Valley, CABuilt 1967 · S/N D-8636N7049NJ M Williams LLC · Stockton, CAFirst renewal noticeBuilt 1967 · S/N D-8638N704QSinor Delbert · Ozark, MOBuilt 1956 · S/N D-4883N7050NGuy Darrell G · Marietta, GABuilt 1967 · S/N D-8645N7053NNames Loch K · Eugene, ORBuilt 1967 · S/N D-8646N7058NAeroplanes2 LLC · Indianola, IABuilt 1967 · S/N D-8640N7069NLindley Robert F · Williamson, GABuilt 1967 · S/N D-8658N706CMSquibb Jeffrey T · Elizabeth, PABuilt 1959 · S/N D-6173
Back to AD 94-20-04 R1