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.

N325DDQuick Michael D · Middletown, CAS/N 21062748N3279NTips Frederick J III · San Antonio, TXBuilt 1974 · S/N 21060452N327BWCessna N327bw LLC · Telluride, COBuilt 1974 · S/N 21060166N327CTYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700535N32MCCook Tracy L · Prosper, TXBuilt 1974 · S/N 21060482N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343N32RLVb Glass Company Inc · Jamestown, CAS/N U20605551N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747N331LCEblc Aviation LLC · Hollywood, FLS/N U20605254N33216Avarts LLC · New Castle, DES/N U20602676N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692N33277Niebuhr Bradley A · Morriston, FLS/N U20602708N3327SDavis Blake A · Bellevue, TXS/N 21059127N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136N3337SBeery Bruce M · Lakeland, FLBuilt 1969 · S/N 21059137N333BCMcfadden John L · Cresson, TXBuilt 1977 · S/N 21061848N333DAFavor Michael D · Chico, CABuilt 1976 · S/N 21061289N333FUIntricate Bay Operating LLC · Iliamna, AKBuilt 1977 · S/N U20604126N333GKCenturion210 LLC · Amherst, NHBuilt 1976 · S/N 21061282N333HRWilson Alan E Trustee · Erie, COBuilt 1974 · S/N 21060412N333JWPhillips John Patrick · Cumming, GABuilt 1975 · S/N 21061094N333LB333lb LLC · Fort Worth, TXBuilt 1978 · S/N 21062890N333LHKoelbl Aviation LLC · Whitesboro, TXBuilt 1981 · S/N 21064220N333PSDoran Jeffrey T · Westerville, OHS/N 21060834N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N3360SMohler Earl C · Bonita, CAS/N 21059160N3363YCamlik Air LLC · Wausau, WIBuilt 1978 · S/N 21063145N3364SAir Deeken Ltd · Doylestown, OHBuilt 1969 · S/N 21059164N3365SWinger Cattle Co Inc · Johnson, KSBuilt 1969 · S/N 21059165N3366ST R Webster And Son Inc · Rexburg, IDBuilt 1969 · S/N 21059166N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174N337DMMcwhorter Michael S · Fortuna, CABuilt 1968 · S/N P206-0471N337PCPhantom Technologies LLC · Garden City, IDBuilt 1980 · S/N 21064212N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188
Back to AD 2002-07-01