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.

N6927RSavord George Kevin · Boulder City, NVBuilt 1967 · S/N T210-0327N6929RShelfer Douglas · Arlington, TXBuilt 1967 · S/N T210-0329N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331N6932RBoxwell Avionics · Green Cove Springs, FLS/N T210-0332N6936RKingrey William S III · Richmond, TXBuilt 1967 · S/N T210-0336N6939NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 21063161N6939RGalloway Kyle J · Bradshaw, NEBuilt 1967 · S/N T210-0339N6944RSilcox Cleven L · Sapulpa, OKBuilt 1968 · S/N T210-0344N6945RDonham William David · Odessa, TXS/N T210-0345N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346N6949RElyan Aviation Inc · Palm Springs, CABuilt 1968 · S/N T210-0349N6951YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N P210-00380N6967BChalk 2 Inc · Apple Valley, CABuilt 1978 · S/N 21062857N6967NSand Creek Oil & Gas Inc · Edmond, OKBuilt 1979 · S/N 21063177N6970NSeitz Thomas J · Mission, KSFirst renewal noticeBuilt 1979 · S/N 21063179N6972NEnns Robert B · Cayucos, CABuilt 1979 · S/N 21063181N6976NCenturion Capital Partners LLC · Blue Ash, OHBuilt 1979 · S/N 21063185N6977BCollins Kevin T · Roseville, CABuilt 1978 · S/N 21062862N6979BCenturion Bravo LLC · Houston, TXBuilt 1978 · S/N 21062863N6979NArango Jorge · Mcallen, TXBuilt 1979 · S/N 21063188N6980MPetumenos Timothy James · Anchorage, AKBuilt 1977 · S/N 21062005N6993NSp Aircraft LLC · Moscow, IDBuilt 1979 · S/N 21063202N6994MParish John L Sr · Tullahoma, TNBuilt 1978 · S/N U20604513N699EEMathes Jay B · Ridgecrest, CABuilt 1976 · S/N 21061184N699WWWallis Warren · Barstow, CABuilt 1969 · S/N 21059161N69HZU206 Ice LLC · Pompano Beach, FLS/N U206-1253N69LEEle Motorsports LLC · Dover, DES/N 21062897N69PRAero Inventory LLC · Monroe, GAS/N T210-0321N69WAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1982 · S/N 21064707N6DEE & R Properties Of Florence LLC · Ridgeway, SCBuilt 1978 · S/N 21062802N6HGBagwell Harold G · Garner, NCBuilt 1978 · S/N 21062624N6MFMission Aviation Fellowship · Nampa, IDS/N U20605926N6NTNevada Defense Group LLC · Henderson, NVBuilt 1978 · S/N P21000109N6PDNewcomb Clint · Benton, ARS/N 21061930N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907N700RSTransavia LLC · Wilmington, DEBuilt 1981 · S/N P21000716N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007N701PSLucky US LLC · Merrill, WIBuilt 1977 · S/N 21062339N702BDaly Moses M · Underhill, VTS/N U206-1279N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672N7032QRegistration Pending · Oakwood, OHRegistration pendingBuilt 1976 · S/N U20603067N70506Roesner Liselotte A · Hilton, NYBuilt 1973 · S/N U20602073N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083N70594Non-Typical Airplanes LLC · Malad City, IDS/N U20602084N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085N70598Routh Lucas R · Albert Lea, MNFirst renewal noticeBuilt 1973 · S/N U20602087N707ERCrossbrook LLC · Willoughby, OHBuilt 1977 · S/N 21062337N707KWWaters Aero Marine Inc · South Thomaston, MEBuilt 1975 · S/N U20602619N707WJLandry Don T · Thousand Oaks, CABuilt 1977 · S/N U20604054
Back to AD 2002-07-01