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.

N4318CEakins Clifford P · Bloomfield, IABuilt 1955 · S/N 7EC-323N4318LPhillips Matthew L · Las Cruces, NMBuilt 1966 · S/N 17254387N4318UCragg Gordon · Georgetown, TXBuilt 1964 · S/N 15060318N4319BClay Charles E · Alhambra, CABuilt 1955 · S/N 26663N431DKrause Derris O · Cumberland, MDS/N 15066583N4321CWeiss Elliott · Fresno, TXS/N 7EC-326N4321UBurdett Michael R · Dawsonville, GABuilt 1964 · S/N 15060321N4322CSparrowhawk Aviation LLC · Moraine, OHS/N 7EC-327N4322LShastri Milind J · Seminole, FLBuilt 1966 · S/N 17254391N4323LReed Darran K · Whitney, TXBuilt 1966 · S/N 17254392N4324CCornfield Cruisers LLC · Urbandale, IABuilt 1955 · S/N 7EC-333N4324LMesa Aviation LLC · Alpine, TXBuilt 1966 · S/N 17254393N4324UPerot Mark E · Homer, LABuilt 1964 · S/N 15060324N4325LJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1966 · S/N 17254394N43261Haley Billie Jo · San Martin, CABuilt 1946 · S/N 6920N43264Engebretson Eric T · Medford, ORBuilt 1947 · S/N 6923N4326BRopp Doug · Albany, ORS/N 26670N4327UHodges Caleb F · Omaha, TXBuilt 1964 · S/N 15060327N4328CWelch Thomas R · Modesto, CABuilt 1955 · S/N 7EC-337N43292Brooks Douglas L · Stewartstown, NHBuilt 1946 · S/N 6951N4329LHanson Randy J · North Branch, MNBuilt 1966 · S/N 17254398N4329UCarvalho Brandon A · Camarillo, CAS/N 15060329N432DTrollinger Lari D · Wanette, OKBuilt 1964 · S/N 15060762N4330UPalmer Dana G · Gatesville, TXS/N 15060330N4331LOppegaard Craig E · Saint Louis Park, MNBuilt 1966 · S/N 17254400N4332HMcchesney Corey D · New Berlin, WIBuilt 1948 · S/N 15-122N43339Gregory Raymond P · Waconia, MNBuilt 1947 · S/N 6998N4333EWatters Robert K · Dwight, ILBuilt 1948 · S/N 11CC-186N4333LDover Amanda · Littleton, NCBuilt 1966 · S/N 17254402N4334CEyring Joshua S · Diamond, OHBuilt 1955 · S/N 7EC-347N4334UTusko Air LLC · Choctaw, OKBuilt 1964 · S/N 15060334N4335LClifford Gary G · Titusville, FLBuilt 1966 · S/N 17254404N4335UHarrison Wesley V · Kemah, TXBuilt 1964 · S/N 15060335N4336BAlthens Levi W · Wasilla, AKBuilt 1955 · S/N 26680N4336CRegistration Pending · Billings, MTRegistration pendingS/N 7EC-352N4336LWiff Robert A · Tahuya, WABuilt 1966 · S/N 17254406N4337CSpence Stephen L · N Richland Hills, TXS/N 7EC-353N4337LWirt James · Goldsby, OKBuilt 1966 · S/N 17254408N4337UStroope Jerry S · Pearland, TXBuilt 1964 · S/N 15060337N4338LInsco Kay · Martin, TNBuilt 1966 · S/N 17254409N4339BCurrie Andrew C · Oscoda, MIBuilt 1955 · S/N 26683N4339CMurray Erwin L Jr DBA · Emporium, PABuilt 1955 · S/N 7EC-355N433APetty Clifford C · Cedar Hill, TXS/N 4615N433DLBlue Sky Transport LLC · Deland, FLBuilt 2007 · S/N 1013-2007N433HKuhn Darrell G · Irma, WIBuilt 1956 · S/N 7BCM-159N4340BMuehl John M · Maryland, NYBuilt 1955 · S/N 26684N4340CAndersen Andy · Sutton, AKBuilt 1955 · S/N 7EC-356N4340UBenford Kenneth R · Haleyville, ALS/N 15060340N4341CHofer Perry L · Doland, SDBuilt 1955 · S/N 7EC-357N4341EJeffryes Richard B · Creswell, ORBuilt 1948 · S/N 7DC-2
Back to AD 94-05-05 R1