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.

N9685AVarvayanis Mark · Dryden, NYBuilt 1979 · S/N 360N96861Mizer James D · Hailey, IDFirst renewal noticeBuilt 1946 · S/N 9161N9687AHolbrook James A · Burnet, TXBuilt 1950 · S/N 15408N9688ASmith Herschel C III · Panama City, FLBuilt 1952 · S/N 15409N968CT968ct Aircraft Leasing LLC · Spanish Fork, UTBuilt 1999 · S/N C0068N968SWLessor Mark E · Boise, IDBuilt 1953 · S/N 18-1444N9691ABernette Allan E · Wisconsin Rapids, WIBuilt 1950 · S/N 15412N9694AOgilvie Adam P · Loveland, COBuilt 1950 · S/N 15415N9696ABingham John R · Leawood, KSBuilt 1987 · S/N 1319N96970Harbison Seward W · Delta Junction, AKBuilt 1946 · S/N 9270N969DJJohnson David C · Raleigh, NCBuilt 2006 · S/N 002N96BJCrain James Bruce · Enid, OKBuilt 1997 · S/N 001N96JSchmitz Patrick A · Wynot, NES/N S-1N96LCDomich Jeffrey E · Petaluma, CABuilt 2006 · S/N AL-1075N96LHFfrench Lawrence R Jr · Austin, TXS/N 6720D69BN96RRDocter David Alan · New Braunfels, TXBuilt 1959 · S/N 47025N96SRFuts Enterprises LLC · Anchorage, AKBuilt 1998 · S/N 3-M-1N9702TStricklin Lance A · Fort Greely, AKS/N 47502N9703APease Matthew · Belgrade, MEBuilt 1949 · S/N 19164N9703TBlock Douglas · Pearl City, ILBuilt 1960 · S/N 47503N9706TStoddard Micah J · Boise, IDBuilt 1960 · S/N 47506N9706ZGroenewegen Bruce C · Snohomish, WAS/N 1N9709AMckibbon Paul Lee · Millsap, TXBuilt 1949 · S/N 19170N9710TTrzynka Dean A · Iron River, WIBuilt 1960 · S/N 47510N9713ARueckl Randall L · Hortonville, WIBuilt 1950 · S/N 19403N9714AReinoehl Gregg A · Reelsville, INBuilt 1949 · S/N 19175N9715AGarry L Lewis · Livingston, LABuilt 1949 · S/N 19176N9718FGay George M · Cordele, GABuilt 1964 · S/N 14338N971AAHobgood David · Bartow, FLBuilt 1966 · S/N 15065572N971DHaley Robert Jay · Livermore, CAS/N RD-1N9721NGmk Aviation LLC · Brighton, MIS/N 661N9722TFoust Richard W · Minneapolis, KSBuilt 1960 · S/N 47522N9723TLuinstra Lee Vernon · Benton, KSBuilt 1960 · S/N 47523N9725TAnderas Per R · Green Bay, WIS/N 47525N9726HHarbaugh Scott A · Belle Valley, OHBuilt 1947 · S/N G-82N9726TBuettner Casey R · Kearney, NES/N 47526N9727ACaughlin David Drew · Boise, IDBuilt 1950 · S/N 19404N9727TRogers Bob · Mountain Green, UTBuilt 1960 · S/N 47527N9728ADailey Brian A · Strongsville, OHBuilt 1950 · S/N 19405N9728TBanks Trevor A · Thomaston, GABuilt 1960 · S/N 47528N9729ABaker Benjamin D · Catasauqua, PABuilt 1949 · S/N 19190N9729TGibbs David F · Greenville, NCBuilt 1960 · S/N 47529N972MAAir Repair Inc · Easton, MDBuilt 1967 · S/N 15067551N9731ANorbury Frank R · Scottsdale, AZBuilt 1949 · S/N 19192N9731TKarren Robert E · Mountain Home, IDS/N 47531N9732AMoremen Joshua · Sagle, IDBuilt 1949 · S/N 19193N9734AGreen Theodore G II · Burlington, WIBuilt 1949 · S/N 19195N9738ADemio Douglas · Westbrook, CTBuilt 1949 · S/N 19199N973CCTalley John T · Clifton, TXBuilt 2008 · S/N CC11-00075N973KGRichard Mervin J Jr · Washington, DCBuilt 1961 · S/N 17248989
Back to AD 94-05-05 R1