AD 2002-07-01

Registered aircraft · 3,466

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-07-01')
    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-07-01')
  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.

N46MRDavin Matthew · Ridgecrest, CABuilt 1975 · S/N 21060778N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105N46PKTensas Taildraggers LLC · Saint Joseph, LABuilt 1978 · S/N U20604437N4712KMclellan Bruce A Trustee · Bend, ORBuilt 1979 · S/N P21000262N4714CGorman Aviation LLC · Bartlesville, OKBuilt 1979 · S/N 21063596N4715WKelley Christopher L · La Quinta, CABuilt 1980 · S/N P21000624N4716XJessup Sheila · Dublin, CABuilt 1980 · S/N U20605527N4717CCt Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 21063598N4720CNesbit Gary M · West Linn, ORBuilt 1979 · S/N 21063601N4720PKlingler Larry R · Wolfeboro, NHBuilt 1978 · S/N P21000090N4720YKraemair Aviation LLC · Sauk City, WIBuilt 1980 · S/N 21063992N4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 21063993N4726UMonogram Aviation Services LLC · Coeur D Alene, IDS/N U20605070N4726YMeisner David B · Meridian, IDBuilt 1980 · S/N 21063994N4729CSullivan David C · St George, UTBuilt 1979 · S/N 21063604N472NMMission Aviation Fellowship · Nampa, IDS/N 20700786N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272N4741XRessel Erik P · Lakewood, COBuilt 1980 · S/N U20605529N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530N4744CDesert Aviation LLC · Kingman, AZBuilt 1979 · S/N 21063609N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275N4746U4746u LLC · Sherman Oaks, CABuilt 1979 · S/N U20605079N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611N4747KFloyd Don B · Snohomish, WAFirst renewal noticeBuilt 1979 · S/N P21000278N474AWCenturion Aviation LLC · Ada, MIBuilt 1981 · S/N P21000652N4752KAraiza Fernando A · Tucson, AZBuilt 1979 · S/N P21000283N4753UTurchan Robert H · Scottsdale, AZBuilt 1983 · S/N 21064811N4755KPhilmar LLC · Oshkosh, WIBuilt 1979 · S/N P21000286N4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21063613N4757KGirard Gregory M · Tucson, AZBuilt 1979 · S/N P21000288N4758KRuvo Scott J · Augusta, NJBuilt 1979 · S/N P21000289N4760CJaars Inc · Waxhaw, NCS/N U20605805N4760KWhitton Aviation LLC · Mesa, AZS/N P21000291N4761AAmarel Robert E Jr · Yuba City, CABuilt 1983 · S/N P21000821N4761CForbis Aviation LLC · Calera, OKBuilt 1979 · S/N 21063617N4761KLyman Leslie F · Walnut Grove, CABuilt 1979 · S/N P21000292N4767UDeckload Aviation LLC · Kodiak, AKBuilt 1979 · S/N U20605091N4768KJohnson Durwood · Beaumont, TXS/N P21000299N4768PBoone Patrick J · San Antonio, TXBuilt 1978 · S/N P21000101N4769KSpirit 210 LLC · Missoula, MTBuilt 1979 · S/N P21000300N476LSHoffman Anthony J Trustee · Hillsboro, ORBuilt 1976 · S/N U20603283N4770KPaulk Charles Jr · Naples, FLBuilt 1979 · S/N P21000301N4771KAshby Kenny · Mead, COBuilt 1979 · S/N P21000302N4773CDickert Daniel · Cross City, FLBuilt 1979 · S/N 21063621N4773KReason Farms · Yuba City, CABuilt 1979 · S/N P21000304N4773PCoeur De Air LLC · Mcminnville, ORBuilt 1978 · S/N P21000102N4773UFins Fur & Feathers Flying LLC · King Salmon, AKBuilt 1979 · S/N U20605094
Back to AD 2002-07-01