AD 2002-08-03

Registered aircraft · 276

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:2002-08-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-08-03')
  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.

N90BZMirand Alexander A · Huntington Beach, CAS/N 408N91HBSale Reported · Hickory, NCSale reportedBuilt 1985 · S/N 2004N920DPEnstrom Helicopter Corp · Menominee, MIS/N 2182N9238Cronite Global Corp · Parsippany, NJBuilt 1974 · S/N 229N9244Wahner Rudolf M Jr Trustee · Aston, PABuilt 1974 · S/N 202N9266Olivers Helicopters Inc · Hampshire, ILBuilt 1974 · S/N 216N9274Just Right Solutions LLC · Negaunee, MIS/N 248N9285November 9285 LLC · Higden, ARBuilt 1978 · S/N 1003N93DASeptember Bravo Enterprises LLC · West Olive, MIBuilt 2004 · S/N 2102N93GPHorizon Helicopters Inc · Newark, DEBuilt 2005 · S/N 2117N942MACorderman Michael · Armstrong, IABuilt 1988 · S/N 754N9552Runge Kerry A · Crystal Lake, ILBuilt 1978 · S/N 056N9563Marzich Frank M · Rockford, ILBuilt 1971 · S/N 076N9565Bailey Gordon J · Fayetteville, GAS/N 088N9568Medic Choppers LLC · Springdale, ARBuilt 1972 · S/N 091N9573Styer David B · Pendleton, ORBuilt 1972 · S/N 131N9576Roznick John A · Stillwater, MNBuilt 1972 · S/N 133N9590Stone Heli LLC · Carrollton, GABuilt 1973 · S/N 128N9591Freelance Enterprise LLC · Clayton, WABuilt 1973 · S/N 122N9604Medic Choppers LLC · Springdale, ARS/N 154N962SMWheels Flying Service LLC · Kalispell, MTBuilt 2007 · S/N 2132N965CCannon Travis H II · Corinth, TXBuilt 2013 · S/N 2137N976XMackechnie Martin J · Palm Harbor, FLS/N 2140N98FWHysell Donovan W · Atwater, OHBuilt 1998 · S/N 811N99YCStyer David B · Pendleton, ORS/N 766N9GPGrangaard Orin T · Yerington, NVFirst renewal noticeS/N 252
Back to AD 2002-08-03