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.

N5690DRolfe Cameron R · San Mateo, CABuilt 1978 · S/N 1154N5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 477N5690PMultiaero Corp · Brooklyn, NYS/N 475-2N5691MBrowning Robert F · Washington, DCBuilt 1980 · S/N 485-2N56926Bitwell Construction LLC · Hartville, OHS/N 1188N5692YSilverado Sales Inc · Orem, UTBuilt 1980 · S/N 494-2N5693RWaters Willie Frank Jr · Willits, CAS/N 1194N5694AStyer David B · Pendleton, ORBuilt 1980 · S/N 491-2N5694NBegley Edward · Glasgow, KYS/N 1197N5695AJacob Ricker · Ranchester, WYS/N 1201N5696MHubbard Benjamin L · Quogue, NYBuilt 1980 · S/N 502-2N5697MStanton Mark I · Spokane, WAS/N 1209N5698ELrh Equipment LLC · Pendleton, ORS/N 506-2N56999Lofty Images LLC · Owosso, MIS/N 517N5699DClear Lake Management Corp · Wilmington, DEBuilt 1981 · S/N 510N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220N5699ULrh Equipment LLC · Pendleton, ORS/N 511N5699VMesmer Robert F · Grand Island, NYBuilt 1981 · S/N 512N56UD&M Aviation Inc · Amelia, OHS/N 139N572HCordrey Kenneth R · Delmar, DEBuilt 1976 · S/N 356N58FSClark Mitchell P R · Drewsey, ORS/N 2108N594HKeading Helicopter LLC · Shoshone, IDFirst renewal noticeBuilt 1977 · S/N 1074N595ARMiddle Fork Aviation LLC · Meadowview, VAS/N 1182N59AXCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1982 · S/N 1227N59FSRegistration Pending · Yazoo City, MSRegistration pendingBuilt 2005 · S/N 2109N600RBGates Steven · Midlothian, TXBuilt 1974 · S/N 247N602HKing John H · Trumansburg, NYBuilt 1977 · S/N 1077N613AHEnstrom Helicopter Corp · Menominee, MIS/N 2180N61GGCoggin Randall · Longview, TXS/N 1178N624CECertified Equipment Inspections LLC · Washington, PAS/N 462N624HNeed For Speed Inc · Dover, DEBuilt 1977 · S/N 1078N62VATiger 17 LLC · Wilmington, DEBuilt 1997 · S/N 2081N631DPHeritage Rotors LLC · De Leon Springs, FLBuilt 1980 · S/N 492-2N643HHagglund Caleb J · Pendleton, ORS/N 396N646HStyer David B · Milton Freewater, ORBuilt 1977 · S/N 1099N652MTThomas Michael W · Prescott, WABuilt 1989 · S/N 2043N656XMackechnie Martin J · Palm Harbor, FLS/N 784N663DSButler Raymond · Port Lavaca, TXBuilt 1991 · S/N 2065N665HHouchin Thomas J · Pittsburgh, PABuilt 1977 · S/N 1093N666CFTrofimchuck Matthew P · Coal City, ILBuilt 1977 · S/N 1069N666MDLrh Equipment LLC · Pendleton, ORS/N 338N668ZEEnstrom Helicopter Corp · Menominee, MIS/N 2181N669CEOne Pft LLC · Denton, MTBuilt 1992 · S/N 787N698MBravo Zulu International Ltd · Las Vegas, NVBuilt 1982 · S/N 1509N700ATMoore Stirling · Douglas, WYS/N 1193N704DFrancis Greg · Texarkana, TXBuilt 1988 · S/N 2025N70719Emerson Frayne · Stanfield, ORS/N 1072N713CHHopkins David Martin · Bell Buckle, TNS/N 2037N726RMEaves Christopher C · Salt Lake City, UTBuilt 1997 · S/N 810N728DBStyer David B · Pendleton, ORBuilt 1993 · S/N 332
Back to AD 2002-08-03