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.

N3137HBeaty Larry · Newport Beach, CABuilt 1946 · S/N 3762N3137NLuana John L · Deford, MIBuilt 1947 · S/N 13395N3138XBoardman Thomas M · Greenwich, NYBuilt 1966 · S/N 15064538N3139HRegistered aircraftBuilt 1946 · S/N 3764N313BCVan Meter Benjamin · Tumwater, WABuilt 2009 · S/N AL-1149N3140ASzablowski Walter · Riegelsville, PABuilt 1953 · S/N 25784N3140HLayne John A · Danville, INBuilt 1946 · S/N 3765N3140JSmith Franklin R Sr · York, SCBuilt 1966 · S/N 15065840N3140XGerasimov Gennady · Jefferson City, MOBuilt 1966 · S/N 15064540N3141AHoppe Joel A · Mankato, MNBuilt 1953 · S/N 25785N3141BGoettemoeller Matthew W · Oldtown, IDBuilt 1952 · S/N 25383N3141HSheddan Henry W · Live Oak, FLS/N 6081N3141NSale Reported · Lone Jack, MOSale reportedBuilt 1947 · S/N 13399N3141VRenner Thomas J · Williston, NDS/N 15076399N3141XMalo Lee M · Peabody, MABuilt 1966 · S/N 15064541N3142AKrueger Robert C · Glenburn, MEBuilt 1953 · S/N 25786N3142NMcdonald Collin D · Carthage, TNS/N 13400N3143ASkyline Holdings LLC · Big Lake, AKBuilt 1953 · S/N 25787N3143HBuckley Barney P · Colfax, WABuilt 1946 · S/N 3768N3143VWebb Hunter · Altonah, UTBuilt 1974 · S/N 15076401N3144JChaffey Union Junior College District · Alta Loma, CABuilt 1966 · S/N 15065844N3147HRegistration Pending · Grand Forks, NDRegistration pendingBuilt 1946 · S/N 3772N3147XSuperior Golf Course Maintenance LLC · Plantation, FLBuilt 1966 · S/N 17255297N3148JWoerle Edward R · Rossville, TNBuilt 1966 · S/N 15065848N3148NGoerger Allan E · Barney, NDBuilt 1947 · S/N 13406N3148VConnor Gavin · Owensboro, KYBuilt 1974 · S/N 15076402N3148XJennings Dewey S · Springfield, MOBuilt 1966 · S/N 17255298N3149AOlson Karl D · Fairbanks, AKBuilt 1953 · S/N 25793N3149HGregory Vernon L · Swansea, SCS/N 3774N314AGAntique And Classic Aircraft International Inc · Sound Beach, NYS/N 3N314BWCooper Matthew A · Seattle, WABuilt 1952 · S/N 25389N314DMMarshall Donald R · Cape Girardeau, MOS/N 1001N314JMJ B Flying Club Inc · Weymouth, MABuilt 1947 · S/N 12243N314SKPerkins Robert · Laguna Vista, TXBuilt 2008 · S/N 601-059SN3150JKeown Kyle W · Saint Charles, MOBuilt 1966 · S/N 15065850N3150NPutnam Michael C · Topeka, KSBuilt 1947 · S/N 13408N3150PPeterson Craig A · Sweeny, TXBuilt 2013 · S/N 2N3151ADavis William G · Mercer, MEBuilt 1953 · S/N 25795N3151NWayman Richard · Crystal, MNBuilt 1947 · S/N 13409N3153ALea Robert W · Minter City, MSBuilt 1953 · S/N 25797N3154BRegistration Pending · Turner, MTRegistration pending, pending cancellationBuilt 1952 · S/N 25396N3155VHutchinson Kevin J · Poplar Grove, ILS/N 15076403N3156ANorth American Aero LLC · Madison, NEBuilt 1953 · S/N 25800N3156HFoster Scott R · Federal Way, WABuilt 1946 · S/N 3781N3156VSchwartz Amy A · Chandler, AZBuilt 1974 · S/N 15076404N3157AToyon Properties LLC Series N3157a · Waco, TXBuilt 1953 · S/N 25801N3157NRich Melody L Trustee · Port Hueneme, CABuilt 1947 · S/N 13415N3158BFischer Gregory · Willow, AKBuilt 1952 · S/N 25400N3158HReed Brenda L · Hopland, CAS/N 3783N3158NAlbrecht Romaine C · Ohio, ILBuilt 1947 · S/N 13416
Back to AD 94-05-05 R1