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.

N6598WValiair Lc Trustee · Casper, WYS/N P21000802N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729N6602CSnip Robert C · Telluride, COBuilt 1980 · S/N 21063926N6606YBlackwell Benjamin D · Scottsdale, AZBuilt 1981 · S/N 21064457N6609WKingsford Smith LLC · Tulsa, OKBuilt 1982 · S/N P21000804N6610RSonday Terrance · Spring, TXBuilt 1984 · S/N U20606822N6614YBoots LLC · Clay Center, KSS/N 21064460N6617CN6617c Inc · Calumet City, ILBuilt 1980 · S/N 21063933N661KBBaldeo Kessho I · Bay Shore, NYBuilt 1974 · S/N 21060292N6621AJc Investors Group LLC · Coral Springs, FLBuilt 1979 · S/N 21063559N6622CMidnight Flight LLC · Wells, TXBuilt 1980 · S/N 21063936N6622YSierrakilo LLC Trustee · Lewes, DES/N 21064464N6625NRogers Charles W Trustee · Newbury Park, CABuilt 1978 · S/N 21063126N6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N P21000194N6638NIsr Aviation LLC · Wilmington, DEBuilt 1978 · S/N 21063129N6653BWilson Gale E · Lewiston, IDS/N 21062806N6657BBullock Zachary Daniel · Stuttgart, ARS/N 21062808N665SWAmerican Classic Corp · Ludington, MIBuilt 1980 · S/N P21000588N6661NSmith Joel L · Cedar Park, TXBuilt 1978 · S/N 21063137N6667NSmith William F · Hindsville, ARBuilt 1978 · S/N 21063141N6669BConstantia Group LLC · Green Cove Springs, FLBuilt 1978 · S/N 21062814N666ESSharkey Kenneth J · Haverford, PAS/N 21062120N666JGGronemeyer Jens · Deland, FLBuilt 1981 · S/N P210-00657N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816N6677RTre Aviation Corp · Wilmington, DES/N 21059654N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N668DB686 Aviation LLC · Lakewood, COBuilt 1975 · S/N 21061003N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150N669EBBauman Ed · Casstown, OHBuilt 1975 · S/N 21061065N66CEM&S Real Estate Management Inc · Granbury, TXS/N 21061391N66DFClark Samuel D Trustee · Wilson, WYBuilt 1977 · S/N 210-621-41N66DTTucker Family Agricultural Co LLC · Kiowa, KSS/N 21058931N66GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 20700657N66MLBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 21062598N66RHBoniek Johann C · Nederland, COBuilt 1972 · S/N U20601873N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154N66VSEurovation Inc Trustee · KematenBuilt 1979 · S/N P21000421N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200N670JHNatural Resources Engineering Co Pa · Superior, WIFirst renewal noticeBuilt 1978 · S/N U20604489N6722BJca Aviation LLC · Safford, AZS/N 21062826N6735MJenks John W · Marlton, NJBuilt 1977 · S/N 21061987N673DKBh Aero LLC · Hanover, MNBuilt 1979 · S/N 21063479N6778MNikodem Daniel E · Lakeland, TNBuilt 1977 · S/N 21061990N6779BRegistered aircraftBuilt 1978 · S/N 21062829N677PCTraven Ricardo Siro · Matthews, NCS/N P21000677N678CTSanborn Thomas W · College Station, TXBuilt 1978 · S/N P21000019N67CHPrestige Aviation LLC · Lake Havasu City, AZBuilt 1981 · S/N 21064354
Back to AD 2002-07-01