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.

N503TW25th Infantry Division Huey LLC · Bend, ORS/N 65-09961 N50513Northwest Helicopters LLC · Olympia, WAS/N 65-09805 N5073XMartins Dusters Inc · Colusa, CABuilt 1963 · S/N 63-8622 N509JSSpokane County Sheriffs Office · Spokane, WAS/N 73-21824 N51114U S Department Of State Inl/A · Melbourne, FLS/N 72-21567 N512SAAlabama Law Enforcement Agency · Montgomery, ALS/N 74-22512 N514DRMachugh Dave · Pasco, WABuilt 1972 · S/N 72-21622 N514LCLake County Sheriffs Department · Griffith, INS/N 74-22479 N51AGBrown Helicopter Inc · Pensacola, FLBuilt 1971 · S/N 71-20178 N51BRNorthwest Helicopters Inc · Olympia, WAS/N 69-15677 N5206QU S Department Of State Inl/A · Melbourne, FLS/N 73-21826 N5207EUS Department Of State Inl/A · Melbourne, FLS/N 73-21670 N5207UU S Department Of State Inl/A · Melbourne, FLS/N 73-21729 N533AWBrown Helicopter Inc · Pensacola, FLS/N 7221533 N538CBTradehawk International LLC · Ramona, CAS/N 6616118 N53AGCoastal Helicopters Inc · Panama City, FLBuilt 1972 · S/N 72-21588 N540FUAdf Helicopters Inc · Brewster, WABuilt 1999 · S/N 157190 N541FAUsda Forest Service Fepp · Irvine, CAS/N 66-16335 N545DFNevada Division Of Forestry · Minden, NVS/N 70-16401 N5517NBase Camp Holdings LLC · Kalispell, MTBuilt 1967 · S/N 67-17391 N567VFKash Helicopter Services LLC · Mount Vernon, ILBuilt 1966 · S/N 65-10016 N569SSBrevard County Sheriffs Office · Merritt Island, FLS/N 73-21857 N569WCAdesco LLC · South Naknek, AKBuilt 1972 · S/N 72-21569 N56CFVertol Systems Inc · Destin, FLBuilt 1964 · S/N 64-13880 N574PDRegistration Pending · Arbuckle, CARegistration pendingBuilt 1968 · S/N 68-16574 N57KAHagglund Carl D · Pendleton, ORBuilt 1966 · S/N 66-16657 N58468Long-Line Leasing LLC · Saratoga Springs, UTBuilt 1971 · S/N 71-20298 N597ECounty Of Kern · Bakersfield, CAS/N 70-16291 N59HPHansen Albert C · Mojave, CABuilt 1962 · S/N 62-1933 N600MARegenald Michaud Aviation LLC · Willows, CABuilt 1964 · S/N 64-13970 N600SDJefferson County Sheriffs Office · Beaumont, TXS/N 7422357 N606HFAgriforrestal Applications Inc · Cape Coral, FLS/N 638606 N608SDSnohomish County Sheriffs Office · Snohomish, WAS/N 64-13562 N60901Pacific Valley Aviation Inc · Arbuckle, CABuilt 1970 · S/N 70-16232 N6132NUsda Forest Service Fepp · Raleigh, NCS/N 66-16040 N61650Great Falls Property LLC · Auburn, MEBuilt 1997 · S/N 157184 N6165XNorthwest Helicopters I Inc · Olympia, WABuilt 1970 · S/N 157183 N6180AJones Aviation Inc · Biggs, CABuilt 1962 · S/N 62-1994 N61FUAir 1 LLC · Newark, DEBuilt 1967 · S/N 67-19534 N61SPNew York State Police · Albany, NYS/N 74-22370 N624HFArmy Aviation Heritage Foundation Inc · Hampton, GABuilt 1966 · S/N 66-16624 N62619Brunswick County Sheriffs Office · Bolivia, NCS/N 68-16568 N62767Aquila Helicopters LLC · Elliston, MTS/N 62-1915 N633SCAvag Inc · Richvale, CABuilt 1967 · S/N 67-17633 N638HAHelicopter Applicators Inc · Gettysburg, PABuilt 1966 · S/N 67-17302 N64085Agriforrestal Applications Inc · Arcadia, FLS/N 99-100 N64586Charlotte County Sheriffs Office · Punta Gorda, FLS/N 64-13586 N64770Premier Aircraft Services LLC · Bakersfield, CABuilt 1964 · S/N 63-8721 N648HAHelicopter Applicators Inc · Gettysburg, PABuilt 1965 · S/N 64-13888 N64NHNorthwest Helicopters LLC · Olympia, WAS/N 6413672

Back to AD 2000-15-21 R1