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.

N60529My Holdings Inc · Anchorage, AKBuilt 1973 · S/N U20602030N60597Ritchie James E · Grand Junction, COBuilt 1973 · S/N U20602036N60617Williams Robert M · Red Hook, NYBuilt 1974 · S/N 21060595N60636Allard Michael L · Penrose, COS/N 21060596N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136N606TLK C Enterprises Of Basile · Basile, LAS/N 21060545N60766Congdon Douglas J · Fairbanks, AKBuilt 1973 · S/N U20602044N60768Mcgee Jacob Quinton · Anchorage, AKS/N U20602045N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802N60DWJohnson Boyd · Apple Valley, MNBuilt 1981 · S/N P21000696N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N P21000670N60RSVolare Alto LLC · Sanford, NCBuilt 1980 · S/N P21000521N6100FTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 21059000N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715N6103NRed Leasing LLC · Juneau, AKS/N 20700194N6105FShaw Christopher S · Porterville, CABuilt 1968 · S/N 21059005N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258N61105Dorsey Sage · Bend, ORBuilt 1973 · S/N U20602063N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N6112FPcb Inc · Paradise, CAS/N 21059012N6116YSaab35 Draken Inc · Pocono Pines, PAS/N 21064256N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600N611TMWest Michigan Skybirds Inc · Battle Creek, MIBuilt 1978 · S/N 21063037N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021N6124ZMulchatna Air Taxi LLC · Dillingham, AKS/N U20606150N6125FParker Richard A · West Chicago, ILBuilt 1968 · S/N 21059025N6126FCarson John D · Garber, OKBuilt 1968 · S/N 21059026N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260N61273Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602067N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604N61276Sonnys Aviation Inc · Miami, FLBuilt 1973 · S/N U20602069N6127FSmith Phillip · Osprey, FLBuilt 1968 · S/N 21059027N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356N6130CMay And Carter Oil Co · Jackson, GABuilt 1979 · S/N 21063808N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031
Back to AD 2002-07-01