AD 94-05-05 R1

Registered aircraft · 26,232

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.

N704CBLewis Stephen · Hayden, IDBuilt 1976 · S/N 15078496N704CEB2w Corporation · Winona, MNBuilt 1976 · S/N 15078498N704CFWilbur Blake G · Kent, WABuilt 1976 · S/N 15078499N704CMCarpenter Devon W · Mountain Top, PABuilt 1976 · S/N 15078505N704CNTm Aero Marine Inc · North Miami, FLBuilt 1976 · S/N 15078507N704CSHolloway James H · Merritt Island, FLBuilt 1976 · S/N 15078511N704CURogers Gale Allen · Jonesborough, TNBuilt 1976 · S/N 15078513N704CXAlbatross Air Inc · Beaver, WVBuilt 1976 · S/N 15078516N704CYKimbrel Michael R · Shreveport, LABuilt 1976 · S/N 15078517N704DBAndrews University · Berrien Springs, MIBuilt 1976 · S/N 15078519N704DFMaples Andrew L · Wilmington, DES/N 15078523N704DGEastern Florida State College · Cocoa, FLBuilt 1976 · S/N 15078524N704DHDelaware River Flyers LLC · Dover, DEBuilt 1976 · S/N 15078525N704DJStevens Robert L · Wauseon, OHBuilt 1976 · S/N 15078526N704DMTodd R Ray · Lewisville, NCBuilt 1976 · S/N 15078529N704DSMeza Mike A · Aledo, TXBuilt 1976 · S/N 15078534N704DTWasson Tom L · Lakeport, CAS/N 15078535N704DUWinstead Walley K · Leavenworth, KSBuilt 1976 · S/N 15078536N704DXBaskov Andrei · Irvine, CABuilt 1976 · S/N 15078539N704DYSommers Delwyn L · Ochlocknee, GABuilt 1976 · S/N 15078540N704DZWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1976 · S/N 15078541N704EGMartinez Stephen D · Belton, MOBuilt 1976 · S/N 15078548N704ELLancaster Aero LLC · Smoketown, PABuilt 1976 · S/N 15078552N704EMFee Eaman · Pembroke, MABuilt 1976 · S/N 15078553N704ERBeckwith James N · Goldsboro, NCS/N 15078557N704EVJones Janet J · Burlington, VTBuilt 1976 · S/N 15078561N704EXMouw Jacob W H · Palmer, AKBuilt 1976 · S/N 15078563N704EZBellas Business LLC · Kalispell, MTBuilt 1976 · S/N 15078565N704FEOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeBuilt 1976 · S/N 15078570N704FKTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1976 · S/N 15078575N704FNNorman Charles E DBA · Zanesville, OHBuilt 1976 · S/N 15078577N704FPKopache Gregory · Boulder, COBuilt 1976 · S/N 15078578N704FQLapinel Marc P · Long Beach, NYS/N 15078579N704FWHorton Jimmie D · Orlando, FLS/N 15078585N704FXKlingenberg Alice Ruth · Derby, KSBuilt 1976 · S/N 15078586N704FYWassair Aviation LLC · Elkhorn, WIS/N 15078587N704FZDanto Peter J · Concord, CABuilt 1976 · S/N 15078588N704GGillis Ryan T · Kenai, AKS/N 15078638N704GCSteffen Craig · Harrogate, TNBuilt 1976 · S/N 15078591N704GDMacmorris Clifford Jr · Naples, FLBuilt 1976 · S/N 15078592N704GEPester Jerome · Hingham, MTBuilt 1976 · S/N 15078593N704GFDresti Mauro · Pomona, CABuilt 1976 · S/N 15078594N704GGGorin Gustavo A · Statesboro, GABuilt 1976 · S/N 15078595N704GKMcmullen Julie A · Skwentna, AKBuilt 1976 · S/N 15078598N704GRMellor James F · Spanish Fork, UTFirst renewal noticeBuilt 1976 · S/N 15078604N704GXHunt Greg · Rolling Prairie, INBuilt 1976 · S/N 15078610N704HBOtero Alberto A · Fort Pierce, FLBuilt 1976 · S/N 15078614N704HCBrown William C · Columbia, CABuilt 1976 · S/N 15078615N704HDCleary John P · Worcester, MABuilt 1976 · S/N 15078616N704HEFour Sisters Aviation LLC · Fayetteville, GABuilt 1976 · S/N 15078617
Back to AD 94-05-05 R1