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.

N70810Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602097N70822Southern Seaplane Inc · Belle Chasse, LABuilt 1973 · S/N U20602099N7103QLord Hill Aviation LLC · Snohomish, WABuilt 1975 · S/N U20603073N710MHK Bay Air LLC · Homer, AKBuilt 1974 · S/N U20602383N710TDDuke Ray J · Oak Point, TXBuilt 1976 · S/N 21061424N711BGSaybrook Offshore LLC · Guilford, CTBuilt 1982 · S/N P21000806N711FBLing Scott P · Old Saybrook, CTBuilt 1971 · S/N U20601651N711HEDesert West Enterpises LLC · Roswell, NMBuilt 1979 · S/N P21000242N711JFTwin D LLC · Lake City, FLBuilt 1978 · S/N 21062817N711PJRender Chad · Pine Bluff, ARS/N 21061128N711TMPeters James L Trustee · Brighton, MIBuilt 1976 · S/N 21061301N711TWMartens Ruth C · Wheaton, ILBuilt 1978 · S/N 21062654N712VTMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0932N7138QArctic Aviation Leasing LLC · Anchorage, AKBuilt 1975 · S/N U20603074N713TGSelway Construction Group LLC · Moscow, IDBuilt 1979 · S/N U20605218N7144QJungle Breezes Youth Ministries · East Earl, PABuilt 1975 · S/N U20603075N7154DChick Theodore D · Beulah, NDBuilt 1972 · S/N 21059520N7162DFaulkner Winthrop Sewell · Anchorage, AKBuilt 1978 · S/N U20604342N717DKRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1973 · S/N 21060113N717MRSt Johns Aviation Partners II · Beaumont, TXBuilt 1980 · S/N P21000601N718APAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1977 · S/N 21061857N71900Savage David E · American Falls, IDBuilt 1968 · S/N U206-1217N71924Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1968 · S/N U206-1226N71967Lipan Creek Flying Service LLC · Eola, TXBuilt 1969 · S/N U206-1241N71991Bush-Tell Inc · Aniak, AKBuilt 1968 · S/N U206-1247N71994Skydive Buckeye LLC · Goodyear, AZBuilt 1968 · S/N U206-1249N71ESBig Tex LLC · Reedsburg, WIS/N U206-1402N71MKWyeth Patrick · Chino Valley, AZBuilt 1980 · S/N P21000590N71MVVolatile Aero Ventures LLC · Boulder City, NVFirst renewal noticeBuilt 1974 · S/N U20602365N71PHPlh Air LLC · Post Falls, IDBuilt 1975 · S/N U20602651N71WTBear Cat Air LLC · Gun Barrel City, TXS/N 21061505N72027Candy Corn LLC · Missoula, MTBuilt 1968 · S/N U206-1259N72050Petty Line Const Co Inc · Clanton, ALBuilt 1969 · S/N U206-1266N72094Gibertoni James E · Fairbanks, AKBuilt 1969 · S/N U206-1281N720GEHoucke Pascal · Newtown, PABuilt 1975 · S/N 21060671N721Department Of The Interior · Boise, IDBuilt 1981 · S/N U20606256N72106Dahl George Robert · Bethel, AKBuilt 1969 · S/N U206-1282N72117Ott Steve G · Reedpoint, MTBuilt 1969 · S/N U206-1286N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315N721NRUS Department Of The Interior · Boise, IDBuilt 1985 · S/N U20606902N72222Jouppi Kenneth J · Ward Cove, AKBuilt 1969 · S/N U206-1329N7222NN B Tweet & Sons · Nome, AKBuilt 1976 · S/N U20603568N72285Cave Creek Organics LLC · Flagstaff, AZBuilt 1969 · S/N U206-1351N72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeBuilt 1969 · S/N U206-1353N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332N722PDW O Zangger And Son Inc · North Loup, NEBuilt 1976 · S/N 21059833N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651N722SJJackson Stephen L · Belvidere, ILBuilt 1976 · S/N U20603361
Back to AD 2002-07-01