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.

N7391AMitchell Vernon · Waxahachie, TXBuilt 1957 · S/N 29491N7391MAnderson Richard A · Sycamore, ILBuilt 1958 · S/N 55691N7391TAngell Toby L · Stillwater, OKBuilt 1959 · S/N 46991N7392MSantana Marcos · Concord, NCS/N 55692N7393MJ S Imperio Construction And Real Estate Svc/S LLC · Laredo, TXBuilt 1958 · S/N 55693N7393TAppalachian Flight Services LLC · Huntington, WVS/N 46993N7393XSmokovitz Joseph M · Tecumseh, MIBuilt 1962 · S/N 15059493N7394AFreer Lawrence C III · Puyallup, WABuilt 1956 · S/N 29494N7394TSmith Lowell A D · Gresham, ORBuilt 1959 · S/N 46994N7394XRinehart James A · Sebring, FLS/N 15059494N7395TWhalen John F Jr · West Ossipee, NHS/N 46995N7396TFitzsimmons Robert J · Hastings, FLBuilt 1959 · S/N 46996N7396XJons Steven R · Minden, NEBuilt 1962 · S/N 15059496N7397AWillems Scott F · Cottonwood, CABuilt 1956 · S/N 29497N7397MBuck Mark E · St Maries, IDBuilt 1958 · S/N 55697N7397TDirectional Holdings LLC · Missoula, MTS/N 46997N7398THilliard George W · Beeville, TXBuilt 1959 · S/N 46998N7398XSnodgrass James T · Gallipolis, OHBuilt 1962 · S/N 15059498N7399AWheeler James H · Bryan, OHBuilt 1977 · S/N A1500731N7399TLandrover Ltd · Hills, MNBuilt 1959 · S/N 46999N73HBOrians Brian E · Medina, OHFirst renewal noticeBuilt 1974 · S/N 7N73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidBuilt 1966 · S/N 15064948N73LHerald Gregory L · Coatesville, INBuilt 1963 · S/N 17250283N73PCMedearis Jeff W · Plevna, MTS/N 7ECA-48N73PMSmith David James · Fort Mcdowell, AZBuilt 1970 · S/N 700018N73RJRichard Kent A · Sunset, LABuilt 1966 · S/N 15062833N73TFKlanchar Flying LLC · Benton, ARBuilt 1966 · S/N 17255638N7400AHarrop Brian C · Mesa, AZBuilt 1957 · S/N 29500N7400BHartmann Jeffrey N · Chico, CABuilt 1956 · S/N 7EC-430N7400M7400m Air Inc · Auburn, ALBuilt 1958 · S/N 55700N7400XLandrush Construction LLC · Fairview, OKBuilt 1960 · S/N 17247900N7401BSherman David B · Readfield, MEBuilt 1956 · S/N 7EC-431N7402BRoberts Christopher J · Andover, KSBuilt 1956 · S/N 7EC-432N7402TKnox David B · Mc Arthur, OHBuilt 1959 · S/N 47002N7402XClemson Flying Club Inc · Seneca, SCBuilt 1960 · S/N 17247902N74036Pallen William T · Fargo, NDS/N 25506N7403TKoehn David Scott · Orange Beach, ALBuilt 1959 · S/N 47003N7404MHrevans Cessna 175 LLC · Fairbanks, AKBuilt 1958 · S/N 55704N7404TRaptor Flight LLC · Fort Worth, TXBuilt 1959 · S/N 47004N7405BDennis Rick L · Poughkeepsie, NYBuilt 1956 · S/N 7EC-437N74066Davis Brian L · Antlers, OKBuilt 1966 · S/N 1N7406BKraft Tyrone H · Timber Lake, SDS/N 7EC-438N7407AKremmling Flying Inc · Kremmling, COS/N 29507N7407GStarr Ralph H · Port Orange, FLBuilt 1973 · S/N 15074654N7408AJohnston Lynwood A · Anchorage, AKS/N 29508N7409TJohnson Scott E · Wausau, WIS/N 47009N7410TLepinsky Donald J · Whitehall, MTBuilt 1959 · S/N 47010N7411ACoverdill Robert E · Savoy, ILBuilt 1956 · S/N 29511N7411TMcbain Sarah R · West Warwick, RIBuilt 1959 · S/N 47011N7411XTakagi Mark A · Richland, WABuilt 1960 · S/N 17247911
Back to AD 94-05-05 R1