AD 94-05-05 R1

Registered aircraft · 26,230

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.

N9191ARupert Judson L · West Milton, PABuilt 1950 · S/N 19366N9191BE & D Aviation Sales LLC · Sainte Genevieve, MOBuilt 1958 · S/N 36791N9191UN9191u LLC · California, MDBuilt 1976 · S/N 15078142N9193ASchlafmann Jay R · Mercer, NDBuilt 1949 · S/N 18954N9193BRegistration Pending · Garwood, TXRegistration pendingBuilt 1958 · S/N 36793N9193UVan Buskirk Bill J · Wasilla, AKBuilt 1976 · S/N 15078144N9193ZThacker William E · Chenoa, ILBuilt 1953 · S/N 18-2641N9194AWeathered Brenton W · Poquoson, VABuilt 1949 · S/N 18955N91965Wallace Randall R · Stamps, ARFirst renewal noticeBuilt 1946 · S/N 16390N9196BPeterson James G · Keller, TXBuilt 1958 · S/N 36796N9197AAlmeida Gilbert M · Hilmar, CABuilt 1949 · S/N 18958N9197UWarfel Everett E · Greenwood, DEBuilt 1976 · S/N 15078148N9198AMorse Steven J · Gig Harbor, WAS/N 18959N9198ZMitchell Grant Avery · Fallon, NVBuilt 1946 · S/N 10629N9199BM & H Investment LLC · Montgomery City, MOBuilt 1958 · S/N 36799N919WQStone Jeffrey · Fort Collins, COBuilt 1966 · S/N A-107N91DCCueva Arturo A · Los Angeles, CABuilt 1977 · S/N DC-1N91ERice James L · Mckinney, TXBuilt 1951 · S/N 2N91GHHi-Roller Aviation Ltd · Scenery Hill, PABuilt 2006 · S/N AL-1073N91JJJackson James E · Brainerd, MNBuilt 1946 · S/N 19180N91MAHutchings Mathew J · Camano Island, WABuilt 1948 · S/N 10449N91NMccutchan Clay T · Milton, FLBuilt 1946 · S/N 3980N91PVMassimini Sebastian V · Arlington, VAS/N 1005-2006N91RBlack Pilots Of America Detroit Chapter · Detroit, MIS/N 15067793N91TMitchell Carl D · Gainesville, TXBuilt 1946 · S/N 10244N91TCNorth Valley Aircraft Inc · Valley City, NDBuilt 1979 · S/N 2N91WAStevens James L · Carrollton, GABuilt 1955 · S/N 28090N92003Hopgood Mark R · Park City, UTS/N 16396N9200UCherry Hill Aviation Inc · Freetown, INBuilt 1976 · S/N 15078151N92027Registration Pending · Wallace, CARegistration pendingBuilt 1946 · S/N 16460N9202AWilson Alan Trustee · Waukesha, WIS/N 18963N92031Sanchez Joseph · Walnut Grove, CABuilt 1946 · S/N 16464N9203UAlaskan Mariners Inc · Homer, AKBuilt 1976 · S/N 15078154N9204AConrad William A · Kaukauna, WIBuilt 1949 · S/N 18965N9204BMcelwain Floyd · Saint Joseph, MOBuilt 1958 · S/N 55004N9206ACurrie Andrew C · Oscoda, MIBuilt 1949 · S/N 18967N92077Lee Clarence K · Citra, FLS/N 16510N92084Cavanaugh Cody · Neenah, WIBuilt 1946 · S/N 16517N9208UEllefson Nicholas · Duluth, MNBuilt 1976 · S/N 15078159N92107Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1946 · S/N 16544N9210ASmith Ted · Grant Park, ILBuilt 1949 · S/N 18971N9210UKing Bill R · Cadillac, MIBuilt 1976 · S/N 15078161N9211UMaster Gregory A · Mesa, AZBuilt 1976 · S/N 15078162N9212AMills Byron K · Harrison, ARBuilt 1949 · S/N 18973N9212BRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1958 · S/N 55012N9213BWallace Gary E · La Junta, COS/N 55013N92166Gerdeman Richard F III · Roscoe, ILBuilt 1946 · S/N 16608N92177Thomas Robert A · Bettendorf, IABuilt 1946 · S/N 16617N9217AAlumitank Inc · Harvard, ILBuilt 1955 · S/N 26619N9217UWallace John L · Bethel, AKS/N 15078167
Back to AD 94-05-05 R1