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.

N29022Unifly Inc · Lackawanna, NYBuilt 1972 · S/N 21059783N29059Ens Aviation LLC · Marshall, TXBuilt 1968 · S/N U206-1043N29061Swalling Frederick M · Anchorage, AKBuilt 1968 · S/N U206-1045N29068Jd Flying LLC · Bellingham, WABuilt 1968 · S/N U206-1049N29084D E C Holdings · Hansen, IDBuilt 1972 · S/N 21059798N29110Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1968 · S/N U206-1080N29113Figueroa Angel Lara · Winfield, ALBuilt 1973 · S/N 21059806N29114Grey Goose LLC · Wasilla, AKBuilt 1968 · S/N U206-1084N29127Shivers William L Jr · Friday Harbor, WABuilt 1968 · S/N U206-1097N29130Ernst Gregory R · Eagle Creek, ORS/N U206-1100N29138Allen Brent H · Mammoth Lakes, CABuilt 1973 · S/N 21059815N29142Hall Darryl Wayne II · Wasilla, AKS/N U206-1112N29151Inland Aerial Surveys Inc · Riverside, CABuilt 1968 · S/N U206-1121N29164Iturriria John · Kuna, IDBuilt 1968 · S/N U206-1133N29173Aerial Transport LLC · Wilmington, DEBuilt 1968 · S/N U206-1140N29176Tgr Helicopters · Fresno, CABuilt 1973 · S/N 21059828N29181Wings Of Faith · Stevensville, MTBuilt 1968 · S/N U206-1147N29186Thoroughbred LLC · Kalispell, MTBuilt 1968 · S/N U206-1151N29188Rugger Investment Group LLC · Tustin, CABuilt 1968 · S/N U206-1153N29190Mountain Helicopters LLC · Salt Lake City, UTBuilt 1973 · S/N 21059830N29204Jms Aviation LLC · Waynesville, OHS/N U206-1162N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832N29210Hawkes Brian R · Hamilton, MTBuilt 1968 · S/N U206-1165N29217Dawson Adam J · Eveleth, MNBuilt 1968 · S/N U206-1171N29224Phelan Ricky Ray · Jefferson, ORBuilt 1968 · S/N U206-1176N29278Pancho Moreno Y La Flaca LLC · Camuy, PRBuilt 1973 · S/N 21059852N29289Disarro Wayne · Wasilla, AKBuilt 1968 · S/N U206-1211N29292Skytime Aviation LLC · Tulsa, OKBuilt 1968 · S/N U206-1212N29299Svetic Russell T · Redondo Beach, CABuilt 1968 · S/N U206-1216N29359Cervantes Jose DBA · San Diego, CABuilt 1973 · S/N 21059858N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482N29631Registered aircraftBuilt 1973 · S/N 21059873N29674Snflk Leasing LLC · Andrews, TXBuilt 1973 · S/N 21059875N297DRMingus Mason · Scottsville, KYBuilt 1978 · S/N 62398N297ZEnovi LLC · Las Vegas, NVBuilt 1981 · S/N U20606223N29FCUsda Forest Service Fepp · Raleigh, NCBuilt 1968 · S/N U206-1191N29PMAlly Mohamed Yacoob · Fort Lauderdale, FLS/N U20605769N2DMWiley Post LLC · Lewes, DEBuilt 1970 · S/N 21059305N2KDElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1969 · S/N T210-0436N2RXJbs Enterprises LLC · Hamilton, MTS/N P21000030N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908N2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849N2YROverland Missions Inc · Cocoa, FLS/N U20601737N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879N300EW2f Trade LLC · Collinsville, TXS/N 21061219N300HCPs Air LLC · Evansville, INBuilt 1983 · S/N 21064804N301EBQuesnel William G · Truckee, CABuilt 1978 · S/N 21062524N301RS2f Trade LLC · Collinsville, TXS/N 21062473N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903
Back to AD 2002-07-01