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.

N6492BPatno Delviny A · Daniel, WYBuilt 1978 · S/N 21062775N6492HSpernak Airways Inc · Anchorage, AKFirst renewal noticeBuilt 1979 · S/N 20700544N6492NOrmand Philip M · Tyrone, NMBuilt 1978 · S/N 21063066N6492UWisber Peter F Jr · Perkasie, PABuilt 1979 · S/N U20605489N6492YMiller Gary Lee · Pittsburgh, PABuilt 1981 · S/N 21064404N6493NEagle Cap Leasing Inc · Enterprise, ORBuilt 1978 · S/N 21063067N6493YNeed To Fly LLC · Yukon, OKBuilt 1981 · S/N 21064405N6495NBusiness Trip Corp Inc · Cape Coral, FLBuilt 1978 · S/N 21063069N6499NHelgren Quentin C · Oakland, CABuilt 1978 · S/N 21063073N6501YLively Charters Inc · Summerland Key, FLBuilt 1981 · S/N 21064412N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075N6506GWestern Skyways Inc · Montrose, COS/N 21064406N6506VHarper Dreams LLC · New Smyrna Beach, FLBuilt 1976 · S/N 21061633N6506ZAf Auto Group · San Jose, CABuilt 1981 · S/N U20606301N65093Seaman Michael V · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 21061844N6517APeterson Holding Co · San Leandro, CABuilt 1979 · S/N 21063541N6519ABreen Jerry P III · Center Point, TXBuilt 1979 · S/N 21063542N651SPNew York State Police · Latham, NYBuilt 1986 · S/N U20606996N6526MDapp Eric M · Corvallis, ORBuilt 1977 · S/N 21061973N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186N6529YBbd Lynch Family Lp · Houston, TXS/N 21064421N6530YDelgado Gonzalez Hector · San Diego, CABuilt 1981 · S/N 21064422N6531WInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N P21000791N6532NN6532n LLC · Sioux Falls, SDBuilt 1978 · S/N 21063088N6534NDoxsee Joshua · Beverly, MABuilt 1978 · S/N 21063090N6535YRichardson Jane S · San Angelo, TXS/N 21064424N6537WSilver Eagle Holdings LLC · Jerome, IDS/N P21000793N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913N6542NHill Jonathan G · Dover, NHBuilt 1978 · S/N 21063098N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915N6547NHart Anthony · Promise City, IABuilt 1978 · S/N 21063103N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434N6555YMild Charles F · Harlingen, TXBuilt 1981 · S/N 21064436N6557BFangio Mark · Mckinney, TXBuilt 1978 · S/N 21062786N6562YKp Builders Inc · Pittsburgh, PABuilt 1981 · S/N 21064440N6567YMoeller Gerhard Walter · Goshen, OHBuilt 1981 · S/N 21064442N6568XBarnes Inc · Lewiston, IDBuilt 1980 · S/N U20605950N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962N6589MHaller Eugene Z · East Hampton, NYBuilt 1977 · S/N 21061979N6591NRickey James R · Hanford, CAFirst renewal noticeBuilt 1978 · S/N 21063114N6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N P21000801
Back to AD 2002-07-01