Skip to content

AD 2000-15-21 R1

Registered aircraft · 378

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

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:2000-15-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-21-R1') ORDER BY n_number

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:2000-15-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-21-R1')
  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.

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:2000-15-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-21-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

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

Back to AD 2000-15-21 R1