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.

N8131GTalley Edward P · San Jose, CABuilt 1971 · S/N 21059431N8137GTwo Ten K LLC · Upper Sandusky, OHBuilt 1971 · S/N 21059437N8137LShreve Jerry · Warrensburg, MOBuilt 1974 · S/N 21060624N8138GRab Com Limited · Hayward, CABuilt 1971 · S/N 21059438N8139LWashburn Kyle A · Yukon, OKBuilt 1974 · S/N 21060626N813DMAp-1 LLC · Newman Lake, WABuilt 1975 · S/N 21060946N813SWWolff Scott · Missoula, MTBuilt 1979 · S/N U20605296N8141GBitter Creek Investments LLC · Cascade, IDS/N 21059441N8143GRegistration Pending · Sparks, NVRegistration pendingBuilt 1971 · S/N 21059443N8146QOak Gulch LLC · Killdeer, NDBuilt 1975 · S/N U20603097N8159MHowell Andrew · Pinedale, WYS/N 21062032N81631Kelly Jon B · Anchorage, AKBuilt 1981 · S/N U20606371N8167QCedar Pine Construction Inc · Sturgis, SDBuilt 1975 · S/N U20603099N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803N8198GSky Wagon LLC · Phoenix, AZS/N U20603778N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794N81SCGl Aircraft Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 21059382N81TPPowers Charles M · Greenwood, MSBuilt 1979 · S/N 210-63426N81ZHCarlsbad Raceway Corp · Hemet, CABuilt 1978 · S/N 21062541N8203MBottle Meister Inc · San Luis Obispo, CABuilt 1969 · S/N 21059203N820AHBuffaloe Thomas N · Mancos, COBuilt 1981 · S/N U20606123N8210MPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1969 · S/N 21059210N8219MFair Winds Group LLC · Portage, MIBuilt 1969 · S/N 21059219N8222MFrank Sherril P · Grapevine, TXBuilt 1969 · S/N 21059222N8225MCarlson Farms Inc · Plentywood, MTBuilt 1969 · S/N 21059225N8225QCartoflight Inc · Willoughby, OHBuilt 1976 · S/N U20603109N8229MOlsen Frances K · Bostwick, GABuilt 1969 · S/N 21059229N8233MSixty Nine Kilo LLC · Oakland, CABuilt 1969 · S/N 21059233N8237MMiddle Tennessee State University · Murfreesboro, TNBuilt 1969 · S/N 21059237N8241MVenema-Ashmore Karin · East Dixfield, MEBuilt 1969 · S/N 21059241N8249MRancho Bonito LLC · Oxnard, CABuilt 1977 · S/N 21062039N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763N8252MApplied Olap Inc · Huntsville, ALBuilt 1969 · S/N 21059252N8253MHudak Organization LLC · Cedar Grove, NJBuilt 1969 · S/N 21059253N8253QTogo Aviation Services LLC · Palmer, AKBuilt 1976 · S/N U20603249N8254QTogo Aviation Services LLC · Palmer, AKBuilt 1970 · S/N U2061479N8255QKavik Aviation Services LLC · Palmer, AKBuilt 1975 · S/N U20603116N8256QRegistered aircraftBuilt 1975 · S/N U20603117N8260MCloud Dancer LLC · El Paso, TXS/N 21062040N8261MZaller Anthony J · Phoenix, AZBuilt 1970 · S/N 21059261N8262MThrasher Dennis L · Tucson, AZBuilt 1970 · S/N 21059262N8263GFitzpatrick Dennis B · Mccall, IDBuilt 1977 · S/N U20603784N8264QMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1975 · S/N U20603125N8266MCenturion Aviation LLC · Groveland, FLBuilt 1970 · S/N 21059266N82687Boniek Martin J · Mccarthy, AKS/N U20603424N8271MBoyd David R · San Jose, CAS/N 21062041N8273QHelmericks Isaac J · Palmer, AKBuilt 1976 · S/N U20603134
Back to AD 2002-07-01