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.

N733KDLake Clark Holdings LLC · Port Alsworth, AKBuilt 1978 · S/N U20604772N73408Shade Eric L · Dillingham, AKBuilt 1979 · S/N 20700586N7340UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700407N7341CT Cole Holdings I LLC · Paint Rock, TXBuilt 1980 · S/N 21063939N73467Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700594N7346PIntegrated Avionics Services Inc · Hampstead, MDBuilt 1978 · S/N P21000007N7347NAv8 LLC · Boise, IDS/N U20603624N7349CMcbride Patrick J · Anchorage, AKBuilt 1977 · S/N U20603888N734CXMount Crillon LLC · Juneau, AKBuilt 1978 · S/N U20604823N734EJLavery Sam · Morgantown, WVBuilt 1978 · S/N U20604828N734GWRwr Air Inc · Tok, AKBuilt 1978 · S/N U20604832N734HW206 LLC · Portland, ORBuilt 1980 · S/N P21000602N734HXWaters Aero- Marine Inc DBA · South Thomaston, MES/N U20604837N734JCRegistered aircraftBuilt 1977 · S/N 21062107N734PPKelley Jon B · Anchorage, AKBuilt 1979 · S/N U20604855N734TMCorporate Air Service Inc · North Salt Lake, UTBuilt 1979 · S/N U20604870N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614N734WEMattie Joseph G · Ester, AKBuilt 1979 · S/N U20604883N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616N734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1979 · S/N U20604886N73503Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700599N7351UBlue Waves Holding One LLC · Miami, FLBuilt 1977 · S/N 20700415N7357CPerson Donna Mae · Columbus, NEBuilt 1980 · S/N 21063945N7359CAhlem Charles D · Hilmar, CABuilt 1977 · S/N U20603897N735BTPtmm LLC · Columbus, OHBuilt 1979 · S/N U20604898N735CEKangas Randy P · Fairbanks, AKS/N U20604899N735JTStationair 6 LLC · Corinth, MSBuilt 1979 · S/N U20604930N735LSPatrick Andrew · Boise, IDBuilt 1979 · S/N U20604937N735MPHelms Aviation Inc · Long Lake, NYBuilt 1979 · S/N U20604940N735MWWaddell Byron · Henderson, NVBuilt 1979 · S/N U20604942N735MYVanderpool Robert W · Red Devil, AKBuilt 1979 · S/N U20604943N735QPCulver Marc D · Anchorage, AKBuilt 1979 · S/N U20604952N735XVGps Land Company LLC · Brandon, MSBuilt 1979 · S/N U20604980N7360CKacoyanis John George · Bedford, NHS/N U20603898N73612American Aviation Inc · Page, AZBuilt 1980 · S/N 20700608N7361CFocused Holdings LLC · Wellsville, UTS/N U20603899N73663Summit Lake Aviation Inc · Olympia, WABuilt 1980 · S/N 20700612N7367CRuebling Edward X · Anchorage, AKBuilt 1977 · S/N U20603905N73727Redtail Partners LLC · Moab, UTBuilt 1980 · S/N 20700617N73733Muffett Pat D · Eastsound, WABuilt 1980 · S/N 20700618N7373UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700423N73742Adams Bruce M · Santa Fe, NMBuilt 1980 · S/N 20700619N7375NEllison Air Inc · Anchorage, AKS/N U20603641N73789Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700629N7379UIliamna Air Taxi Inc · Iliamna, AKBuilt 1978 · S/N 20700427N7384CFesco Holdings Inc · Alice, TXBuilt 1980 · S/N 21063951N7384UGrant Aviation Inc · Anchorage, AKBuilt 1978 · S/N 20700431N7386CAgro Engineering Inc · Alamosa, COBuilt 1977 · S/N U20603916N7389NKns Properties · Perry, IAS/N 21063226
Back to AD 2002-07-01