AD 94-05-05 R1

Registered aircraft · 26,230

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.

N98169Honcho Air LLC · Portage Des Sioux, MOBuilt 1946 · S/N 18331N9816MShaw David H · Nenana, AKBuilt 1966 · S/N 93N9816YJones Stephen C · Wadsworth, ILBuilt 1949 · S/N 7FC-400N98178Davis Bret Reed · Boynton Beach, FLBuilt 1946 · S/N 18340N9817JDonahue Patrick J · Carriere, MSBuilt 1975 · S/N A1500626N9817YMurray Luke C · Gregory, SDBuilt 1960 · S/N 7FC-401N98180Moss Frank V · Punta Gorda, FLS/N 18342N9819JFranco Louise A · El Cerrito, CABuilt 1975 · S/N A1500628N9820JBenair LLC · Bonita Springs, FLBuilt 1975 · S/N A1500629N9820TSamson Robert C · Waterford, WIBuilt 1960 · S/N 47620N98216Komara Aaron · Fayetteville, TNBuilt 1946 · S/N 18379N9822JSiskiyou Pacific Inc · Central Point, ORBuilt 1975 · S/N A1500631N9823YCentral Air Parts Inc · Staunton, ILS/N 7JC-17N98246P & E Investments LLC · Coconut Creek, FLS/N 18418N9824TNeufeld Dwayne A · Coeur D Alene, IDBuilt 1960 · S/N 47624N9824YSanzaro Aero LLC · Bunnell, FLS/N 7JC18N9825TLong Duane C · Baskin, LABuilt 1960 · S/N 47625N9828JIcarus Copters LLC · Lancaster, CABuilt 1975 · S/N A1500637N9828TArts Donald W · Lincoln, CABuilt 1960 · S/N 47628N9829TGeske Kenneth A · Thief River Falls, MNBuilt 1960 · S/N 47629N982HEHuddleston Edward A · Oaktown, INBuilt 1945 · S/N 18423N98300Bell Patrick C · Novato, CABuilt 1946 · S/N 18467N9830JJohnsen Christian · Big Bear Lake, CAS/N A1500639N9830TPoe Joshua J · Peculiar, MOBuilt 1960 · S/N 47630N98310Hughes Brian J · Renton, WABuilt 1946 · S/N 18471N98311Reeves Todd J · Mosier, ORBuilt 1946 · S/N 18472N98318Schedel John R · Hernando, FLBuilt 1946 · S/N 18480N9831JHaddix Stanley D · Hagerhill, KYBuilt 1975 · S/N A1500640N9831MPham Hieu T · Steilacoom, WABuilt 1966 · S/N 92N9832JWolfe William Keith · Greenbrier, ARBuilt 1975 · S/N A1500641N98340Das Air Inc · Wilmington, DEBuilt 1946 · S/N 18508N98347Benoit Robert W · Hot Springs, ARBuilt 1946 · S/N 18517N9834THulbert Douglas S · Santa Maria, CABuilt 1960 · S/N 47634N98353Yellow Therapy LLC · Kalispell, MTBuilt 1946 · S/N 18523N9835JCrooks Curtis L · Truckee, CABuilt 1975 · S/N A1500644N9835TVfr Ltd · Wilmington, DEBuilt 1960 · S/N 47635N9836YHaughee Jared · Warsaw, INBuilt 1960 · S/N 7EC-738N9837TSmith Robert M III · Taft, CABuilt 1960 · S/N 47637N9838EErickson Lambert A · Littlefork, MNBuilt 1949 · S/N 7EC-1N9838MWaldor Asherjohn · Ford City, PAS/N 2CN98397Clark Thomas M · Fiskdale, MABuilt 1946 · S/N 18583N98399Francis James E · King City, CABuilt 1946 · S/N 18586N9839JDarling Dudley W · Northborough, MABuilt 1975 · S/N A1500648N9839YHayton James B · Sedro Woolley, WABuilt 1961 · S/N 7FC-451N983AMPivitech LLC · Gravette, ARS/N 1374N98400Cross Thomas Ad · Yacolt, WABuilt 1946 · S/N 18588N98405Wade Danley · Willows, CAS/N 18592N9840JBean James P · Tulsa, OKBuilt 1975 · S/N A1500649N9840YBrown Michael D · Columbia, TNBuilt 1961 · S/N 7FC-436N98413Lutes Richard L · Hampshire, ILBuilt 1946 · S/N 18603
Back to AD 94-05-05 R1