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.

N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197N339DGRegistered aircraftS/N P21000434N339MSMile And A Half High LLC · Sarasota, FLS/N 21062036N33AGSory Bailey B IV · Bozeman, MTS/N 21061637N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632N33UT402wd Holdings LLC · Corpus Christi, TXS/N 21061177N3422Hergenrather Michael · Spring, TXS/N U20602920N342EAAfrican Inland Mission International · Peachtree City, GAS/N U20606197N3432FBierschwale Land Co LLC · Mason, TXBuilt 1977 · S/N 21062407N344AJQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 21063891N345ALItm Aircraft LLC · Charleston, SCBuilt 1974 · S/N 20700262N346CBKombi Brazil Inc · Fort Lauderdale, FLS/N 21060712N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567N34BTWilliams Charles R · Wadsworth, OHBuilt 1973 · S/N 21060130N34FFZwierlein Victor · Grand Prairie, TXBuilt 1976 · S/N U20603334N34KBReilly Donald H · Micco, FLBuilt 1978 · S/N 21062656N34KFRsb Properties LLC · Lewes, DES/N P21000700N34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeBuilt 1979 · S/N P21000307N350GZValiair Lc Trustee · Casper, WYBuilt 1979 · S/N P21000382N350LCDaly Arthur P · El Paso, TXBuilt 1978 · S/N P21000049N350TMJefferies Stanley J · Coos Bay, ORBuilt 1969 · S/N 21059125N35443Registered aircraftBuilt 1973 · S/N 21059992N35498Ray Arthur G · Springdale, ARBuilt 1973 · S/N 21059996N354BSStevenson Bill · Sunrise Beach, TXS/N 210-60381N355TAIsland Amphibs LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1976 · S/N U20603446N355YPlussa Mark George · Clermont, FLBuilt 1980 · S/N 21064137N35677C3 Indutries LLC · Bakersfield, CABuilt 1973 · S/N 21060007N35806Air Dakota Flite Inc · Hettinger, NDBuilt 1973 · S/N 21060011N35837Smernoff Michael J · Des Plaines, ILBuilt 1975 · S/N U20602749N35851Northwest Passage LLC · Anchorage, AKS/N U20602757N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779N35889Torgerson Management Inc · Turtle Lake, WIBuilt 1975 · S/N U20602783N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812N35945Illinois Department Of Transportation · Springfield, ILBuilt 1975 · S/N U20602819N35947Continental Construction Inc · Alpine, WYBuilt 1975 · S/N U20602821N35952Johnson Deborah K · Fairbanks, AKBuilt 1974 · S/N U20602825N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829N35962Barker Aviation LLC · Spearfish, SDBuilt 1975 · S/N U20602833N359BDHoffman Brian T · Flower Mound, TXBuilt 1980 · S/N 21064054N359DACessna 359da LLC · Warsaw, VABuilt 1979 · S/N U20605240N3605PSmith Bryan · Wenatchee, WABuilt 1978 · S/N P21000040N360DLTorgerson Management Inc · Turtle Lake, WIS/N U20606033N360MWMission Wings International Inc · Salem, OHS/N P206-0572N361DCSky West Aviation Inc Trustee · Albuquerque, NMS/N U20605584N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049
Back to AD 2002-07-01