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.

N651GBAir Cav Helicopters LLC · Wilmington, DEBuilt 2005 · S/N 65-10105 N651MHCinema Aircraft Restoration LLC · Las Vegas, NVBuilt 1965 · S/N 65-09651 N658HAHelicopter Applicators Inc · Gettysburg, PABuilt 1968 · S/N 68-15458 N65ADWest Valley Aviation Inc · Five Points, CABuilt 1966 · S/N 66-16439 N660TBAir Cav Helicopters LLC · Wilmington, DEBuilt 1966 · S/N 6601182 N661TXAir Cav Helicopters LLC · Wilmington, DEBuilt 1966 · S/N 6616101 N661UHRegistration Pending · Midlothian, TXRegistration pendingBuilt 1966 · S/N 66-16782 N662MCCharlotte County Mosquito & Aquatic Weed Control O · Port Charlotte, FLS/N 68-16622 N670SPDepartment Of Public Safety · Baton Rouge, LAS/N 7422478 N673DZZych Douglas E · Mckeesport, PAS/N 71-20130 N673WCZych Douglas E · Mckeesport, PAS/N 7321673 N678HAHelicopter Applicators Inc · Gettysburg, PAS/N 71-20297 N679SDBrevard County Sheriff Office · Merritt Island, FLS/N 7321684 N67NHState Of North Carolina · Raleigh, NCBuilt 1967 · S/N 6717282 N6828Northwest Helicopters LLC · Olympia, WABuilt 1966 · S/N 66-00828 N6979ZBell Textron Inc · Fort Worth, TXS/N 66-01026 N703NPLrh Equipment LLC · Pendleton, ORBuilt 1969 · S/N 69-15602 N7042LSouthwest Florida Aviation · Arcadia, FLS/N 70-16398 N7042NAgriforrestal Applications Inc · Arcadia, FLS/N 64-13667 N7091ENorthwest Helicopters LLC · Olympia, WAS/N 67-17350 N7095YNorthwest Helicopters LLC · Olympia, WAS/N 63-08748 N7106SNorthwest Helicopters LLC · Olympia, WAS/N 64-13650 N71083Northwest Helicopters LLC · Olympia, WAS/N 65-09852 N710WDA&P Helicopters Inc · Richvale, CAS/N 65-09761 N7115SCrosswind Leasing LLC · Prescott, AZBuilt 1969 · S/N 69-15580 N7123XNorthwest Helicopters LLC · Olympia, WAS/N 70-16313 N71290Northwest Helicopters LLC · Olympia, WAS/N 70-16517 N7130GJzw Aviation LLC · North Salt Lake, UTBuilt 1966 · S/N 66-16066 N714MQHaus Michael D · Concord, CABuilt 1965 · S/N 65-09576 N71KPKing County Department Of Public Safety · Seattle, WAS/N 70-16314 N71NHNorthwest Helicopters LLC · Olympia, WAS/N 6915394 N7221VSchaper Monte E · Terra Bella, CAS/N 67-17358 N72297American Ag Aviation Inc DBA · Five Points, CABuilt 1967 · S/N 67-17147 N7247CBrown Helicopter Inc · Pensacola, FLS/N 68-16295 N730VBAsa Security LLC · Anchorage, AKBuilt 1965 · S/N 65-9992 N73FUAir-1 LLC · Newark, DEBuilt 1973 · S/N 7321697 N750HPRegistration Pending · Knoxville, TNRegistration pendingBuilt 1970 · S/N 70-16409 N75140Friends Of Army Aviation-Ozark · Ozark, ALBuilt 1971 · S/N 71-20123 N7515SNorthwest Helicopters Inc · Olympia, WAS/N 69-15328 N7515ZNorthwest Helicopters Inc · Olympia, WAS/N 70-16336 N75462Brown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 74-22351 N75707Registration Pending · Hoschton, GARegistration pendingBuilt 1970 · S/N 70-15707 N763WWitham Kyle S · Lakeview, ORS/N 64-13679 N768STMi State Police Field Supp Aviation · Lansing, MIS/N 71-20000 N771ARVertical Access Corp · Lewes, DES/N 66-00906 N774EARoberti Michael A · Gilbert, AZBuilt 1964 · S/N 64-13774 N777GHRugged Flightworks LLC · Big Piney, WYBuilt 1964 · S/N 64-13560 N777SFUsda Forest Service Fepp · Minden, NVS/N 12220 N78NWInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 66-17072 N790RJKing County Sheriffs Office · Seattle, WAS/N 70-16371

Back to AD 2000-15-21 R1