AD 2002-01-31

Registered aircraft · 385

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-01-31')
    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-01-31')
  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.

N3053QWest Valley Aviation Inc · Five Points, CABuilt 1966 · S/N 66-1104N305SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CAS/N 71-20217N307CWBrown Helicopter Inc · Pensacola, FLS/N 7422307N313BNorthwest Helicopters Inc · Olympia, WABuilt 1963 · S/N 63-08765N317CNPasco Sheriffs Office · New Port Richey, FLS/N 73-21802N3181FSalmon River Helicopters Inc · Riggins, IDBuilt 1964 · S/N 64-15486N324MWMountain West Helicopters Of Montana LLC · Missoula, MTBuilt 1965 · S/N 65-09856N3276KMooney Seven Inc · San Antonio, TXBuilt 1967 · S/N 67-19521N333XLCj Air LLC · Nezperce, IDBuilt 1967 · S/N 154951N334WNPope Jim D DBA · Lewiston, IDBuilt 1962 · S/N 62-2097N338WNUsda Forest Service Fepp · Olympia, WAS/N 63-08846N339WNUsda Forest Service Fepp · Olympia, WAS/N 63-12979N340WNUsda Forest Service Fepp · Olympia, WAS/N 65-10081N341WNUsda Forest Service Fepp · Olympia, WAS/N 65-10130N344WNUsda Forest Service Fepp · Olympia, WAS/N 71-20329N345WNUsda Forest Service Fepp · Olympia, WAS/N 72-21629N346WNUsda Forest Service Fepp · Olympia, WAS/N 70-15708N347AMNorthwest Helicopters LLC · Olympia, WAS/N 74-22331N348AHNorthwest Helicopters Inc · Olympia, WAS/N 71-20183N348BHNorthwest Helicopters Inc · Olympia, WAS/N 70-16399N348DMBell Textron Inc · Fort Worth, TXS/N 69-15931N348FBBell Textron Inc · Fort Worth, TXS/N 74-22360N34GDDwind Helicopter Services LLC · Zeeland, MIBuilt 1966 · S/N 66-16345N353RCN353rc LLC · Chelan, WAS/N 6600782N354HFArmy Aviation Heritage Foundation · Hampton, GABuilt 1964 · S/N 69-15354N367CBNorthwest Helicopters Inc · Olympia, WAS/N 70-15736N367JXBell Textron Inc · Fort Worth, TXS/N 66-16200N367KBNorthwest Helicopters Inc · Olympia, WAS/N 66-16906N369UHAmerican Huey 369 Inc · Peru, INBuilt 1970 · S/N 70-16369N370ASJtbam Inc · Lakeside, AZS/N 63-12923N373DHNorthwest Helicopters Inc · Olympia, WAS/N 65-09589N3814BNorthwest Helicopters LLC · Olympia, WAS/N 66-00930N3817BBell Textron Inc · Fort Worth, TXS/N 70-16459N3819NNorthwest Helicopters LLC · Olympia, WAS/N 69-15350N381MUsda Forest Service Fepp · Helena, MTS/N 5409N381RBBell Textron Inc · Fort Worth, TXS/N 70-15718N381TBNorthwest Helicopters LLC · Olympia, WAS/N 70-15738N382ABNorthwest Helicopters LLC · Olympia, WAS/N 69-15026N382DBNorthwest Helicopters LLC · Olympia, WAS/N 66-17120N383PDOver The Top Aviation Inc · Jonesboro, ARBuilt 1968 · S/N 68-16383N387MUsda Forest Service Fepp · Helena, MTS/N 11769N388MUsda Forest Service Fepp · Helena, MTS/N 73-21680N394MUsda Forest Service Fepp · Helena, MTS/N 64-13685N395MUsda Forest Service Fepp · Helena, MTS/N 65-09662N398MUsda Forest Service Fepp · Helena, MTS/N 65-09984N4040PR & R Conner Aviation LLC · Conner, MTBuilt 1965 · S/N 65-7911N404WSPorter Flying Service Inc DBA · Durham, CAS/N 7016404N405PDPowell Kim S · Highlands, TXS/N 64-13930N40690Slikker Flying Service Inc · Buttonwillow, CABuilt 1966 · S/N 66-00816N4069GSlaney Richard C · Eugene, ORS/N 66-16164
Back to AD 2002-01-31