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.

N90154Mathis Ryan Blake · Madison, ALBuilt 1946 · S/N 9219N90155Blanc Christopher F · Renton, WABuilt 1946 · S/N 9220N90163Roehm John P · Clinton, INBuilt 1946 · S/N 9228N90164Boutwell Nathan G · Pelham, NHBuilt 1946 · S/N 9229N90167Reeves Richard E · Lincoln, NEBuilt 1946 · S/N 9232N9016BGray David W · Gnadenhutten, OHBuilt 1957 · S/N 7FC-110N90172Doll J M Smokey · Austin, TXBuilt 1946 · S/N 9237N901742001 LLC · Lakeville, MNBuilt 1946 · S/N 9239N90175Patz Michael · Anchorage, AKBuilt 1946 · S/N 9240N90179Thomason Todd · Harrison, ARBuilt 1946 · S/N 9244N9017BPancake C William Jr · Keyser, WVBuilt 1957 · S/N 7FC-111N90185Harris Frederick John Trustee · Port Townsend, WABuilt 1946 · S/N 9250N9018AGodbold Robert L · Apex, NCBuilt 1949 · S/N 18773N90190Bobka Christian · NorthamptonshireS/N 9255N90192Johnson Dennis F · Detroit Lakes, MNBuilt 1946 · S/N 9257N90195Meggers Roger D · Baker, MTBuilt 1946 · S/N 9260N90199Stoddard David J · Lagrange, WYBuilt 1946 · S/N 9264N901CECross John R · Canton, OHBuilt 1946 · S/N 917N901MSRozelle Kevin · Granbury, TXS/N 074N901RJMiller James A · Granada Hills, CABuilt 1965 · S/N 17253429N901SWWilson Paul C · Jefferson, GABuilt 1964 · S/N 15060734N901UBowling Robert E · Argillite, KYBuilt 1974 · S/N 15076038N9022BMorris Nicholas R · Palmer, AKBuilt 1957 · S/N 7EC-634N9024AHarbick Joshua W · Bend, ORBuilt 1949 · S/N 18779N9026AMoyer Michael · Duarte, CABuilt 1949 · S/N 18781N9027ABrowning Charles R · Fond Du Lac, WIBuilt 1949 · S/N 18782N9029BWyatt Mary Ellen Personal Representative · Weirsdale, FLBuilt 1957 · S/N 7FC-121N902KSSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076244N902MHaworth James M · Canby, ORBuilt 2013 · S/N 658N90302Mendoza Macario · Lancaster, CABuilt 1946 · S/N 316N90305Varnado Jason P · Hattiesburg, MSBuilt 1946 · S/N 319N9030ALimbach Cynthia S · Verona, ILBuilt 1949 · S/N 18785N90316Miller Charles · Bynum, TXBuilt 1946 · S/N 330N9031AKiesling Michael J · Omro, WIBuilt 1949 · S/N 18786N9031BVan Winkle Randy M · Van Buren, MOBuilt 1957 · S/N 7FC-122N90321Jackson Virgil Gene · Kingsport, TNBuilt 1946 · S/N 335N90323High Edward O · Winter Park, FLBuilt 1946 · S/N 337N90325Avent Barry G · Bennettsville, SCS/N 339N9032AProag Services Inc · Mahnomen, MNBuilt 1949 · S/N 18787N9032BThurmond Paul J · Huntley, MTBuilt 1957 · S/N 7FC-123N90333Gattuso Phillip Joseph · Healdsburg, CABuilt 1946 · S/N 347N90334Watson Gary R · Modesto, CABuilt 1946 · S/N 348N9033AEverson David · Redding, CABuilt 1949 · S/N 18788N90340Holliday Mark E · Lake Elmo, MNBuilt 1946 · S/N 354N90341Chileprop LLC · Mimbres, NMBuilt 1946 · S/N 355N9034QLambert Steven D · Henderson, KYBuilt 1979 · S/N DM-11N90352Wilson Stephen A · Granbury, TXBuilt 1946 · S/N 366N90355Williams Mike A · Hartsville, INS/N 369N90356Rokosny Tyler · Port Orange, FLBuilt 1946 · S/N 370N9035BHewitt Robert J · Ringwood, NJBuilt 1958 · S/N 7EC-636
Back to AD 94-05-05 R1