OpenAirDocs.org
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.

N38948Rustad Scott K · Minot, NDS/N 8277-26N3895LGoodyear Aviation Business Services LLC · Buckeye, AZBuilt 1965 · S/N 17254064N3895SPrins Kylee S · Eden, SDBuilt 1963 · S/N 17251095N3896JKhatz Rahm · Austin, TXBuilt 1966 · S/N 15065196N3896LMcphillips Flying Service Inc · Beaver Island, MIBuilt 1965 · S/N 17254065N3896RSabatka John M · Madison Lake, MNBuilt 1966 · S/N 17255396N3896SFishsaildiveeat LLC · North Miami Beach, FLBuilt 1963 · S/N 17251096N3897PAirplane Inc · White Bear Lake, MNBuilt 1955 · S/N 18-4730N3897RPrice William B · Lamar, SCBuilt 1966 · S/N 17255397N3897SMartin Neil T · Peoria Heights, ILBuilt 1964 · S/N 17251097N3898KStubblefield Daniel R · Chino Hills, CABuilt 1948 · S/N 3598N3898ROverlord Aviation LLC · Melbourne, FLBuilt 1966 · S/N 17255398N3898SHangar 20 Flying Club LLC · Climax, MIS/N 17251098N3899KRogers Robert L · Corrales, NMBuilt 1953 · S/N 3599N3899RLockett Joseph Jr · Philadelphia, PAS/N 17255399N38EMMiller Katherine E · Spokane, WABuilt 1980 · S/N 760N38KLuttenbacher Thomas A · Lake Como, FLBuilt 1955 · S/N 5N38LCDamschroder Alexander R · Port Clinton, OHBuilt 2008 · S/N AL-1118N38SMTieder Sheldon D · Rhinebeck, NYBuilt 1946 · S/N 7AC-931N38TDLewis Brian D · Bumpass, VAS/N 15073098N38TGJohnson Tracy W · Odessa, MOBuilt 1946 · S/N 7AC-3292N38VMBueber Alan · Kearney, NEBuilt 2013 · S/N 75-8419N38WCCon-Ag Rentals Inc · Blairsville, GABuilt 2006 · S/N AL-1022N38WTReed Brian A · Kilgore, TXBuilt 1969 · S/N 15071384N38ZMaslen Holbrook · Caldwell, IDS/N LFD-13-4N3900ECanepa Joseph H · Baraboo, WIBuilt 1947 · S/N 11BC-3N3900FNolen Parker · Manson, WABuilt 1958 · S/N 36800N3900HGraziano Thomas K · Benson, AZBuilt 1947 · S/N 4601N3900LShaw Flying Club LLC · Cleveland, MSS/N 17254069N3900SCrowe Tim · Winchester, KYBuilt 1964 · S/N 17251100N3900UHeston Jeffrey W · Warren, OHBuilt 1965 · S/N 15061300N3900VMays Kevin E · West Liberty, KYBuilt 1948 · S/N 18210N3901CAero II Inc · Spartanburg, SCBuilt 1968 · S/N 15069096N3901FCda Maine LLC · Winthrop, MEBuilt 1958 · S/N 36801N3901JHolladay Leonard · Greeley, COBuilt 1966 · S/N 15065201N3901LSan Fernando Aviation LLC · Van Nuys, CAS/N 17254070N3901RMuth Joseph A · Richmond, KYS/N 17255401N3901SEggett Glade · Brigham City, UTBuilt 1963 · S/N 17251101N3902JUltimate Aviation LLC · Lowell, ARBuilt 1966 · S/N 15065202N3902RBotero Jorge · Alexandria, VAS/N 17255402N3902SGooding Flying Club · Gooding, IDBuilt 1963 · S/N 17251102N39031Young Anders A · Chicago, ILBuilt 1941 · S/N 1792N3903FSlattery Gordon C · Chippewa Falls, WIBuilt 1958 · S/N 36803N3903KNuckles Charles A Jr · Suffolk, VAS/N 4N3903RDanielson Bradley K · Willmar, MNBuilt 1966 · S/N 17255403N3903SAt Aero LLC · Wilmington, DEBuilt 1963 · S/N 17251103N3903VMiller Charles G · Anchorage, AKBuilt 1948 · S/N 18213N3904FPedersen Blake A · Clackamas, ORBuilt 1958 · S/N 36804N3904KLone Star Flight Museum · Houston, TXBuilt 1953 · S/N 5N3904SLambert Aviation Service LLC · Washington, PABuilt 1963 · S/N 17251104
Back to AD 94-05-05 R1