Skip to content

Registered aircraft · 42

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

N160DYUnical Air Inc · Arcadia, CAS/N 91-0235 N160EHUnical Air Inc · Arcadia, CABuilt 1988 · S/N 88-0108 N160TNUnical Air Inc · Arcadia, CAS/N 89-0168 N227AJBillings Flying Service LLC · Billings, MTBuilt 1992 · S/N 92-0302 N237CHBank Of Utah Trustee · Salt Lake City, UTBuilt 1982 · S/N MJ003 N237PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 91-0237 N238CHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N MJ005 N238PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 91-0238 N239CHColumbia Helicopters Inc · Aurora, ORBuilt 1981 · S/N MJ006 N242CHColumbia Helicopters Inc · Aurora, ORBuilt 1983 · S/N MJ023 N245CHColumbia Helicopters Inc · Aurora, ORBuilt 1983 · S/N MJ022 N249CHColumbia Helicopters Inc · Aurora, ORS/N MM821 N253PJPj Helicopters Inc · Red Bluff, CABuilt 1991 · S/N 90-0198 N254PJPj Helicopters Inc · Red Bluff, CABuilt 1990 · S/N 89-0138 N257PJPj Helicopters Inc · Red Bluff, CABuilt 1989 · S/N 89-0132 N258PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N (M3407) 91-0258 N259PJPj Helicopters Inc · Red Bluff, CABuilt 1990 · S/N 90-0184 N285PJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 91-0268 N344RAAkch4 LLC · Anchorage, AKBuilt 1987 · S/N 86-1663 N366RAAkch3 LLC · Anchorage, AKBuilt 1992 · S/N 91-0244 N377RAAkch2 LLC · Anchorage, AKBuilt 1993 · S/N 92-0300 N401AJBillings Flying Service LLC · Billings, MTBuilt 1993 · S/N 93-0930 N404AJBillings Flying Service LLC · Billings, MTBuilt 1992 · S/N 92-0297 N405AJBillings Flying Service LLC · Billings, MTBuilt 1992 · S/N 92-0289 N406KTBillings Flying Service LLC · Billings, MTBuilt 1995 · S/N M3662 N40CUUc Helitanker 1 LLC · Arcadia, CABuilt 1989 · S/N 89-0169 N411CHColumbia Helicopters Inc · Portland, ORS/N 87-0079 N412CHColumbia Helicopters Inc · Portland, ORS/N 88-0109 N42CUUc Helitanker 1 LLC · Arcadia, CABuilt 1991 · S/N 91-0270 N43CUUc Helitanker 1 LLC · Arcadia, CABuilt 1990 · S/N 90-0182 N473CHColumbia Helicopters Inc · Aurora, ORBuilt 1993 · S/N 92-0283 N475CHColumbia Helicopters Inc · Aurora, ORS/N 88-0079 N47CUCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1992 · S/N 92-0299 N49CUUc Helitanker 1 LLC · Arcadia, CABuilt 1993 · S/N 93-0934 N562AJBillings Flying Service LLC · Billings, MTBuilt 1990 · S/N 90-0185 N588AJBillings Flying Service LLC · Billings, MTBuilt 1992 · S/N 92-0290 N945CHHeligroup Fire LLC · Missoula, MTS/N 91-0262 N947CHHeligroup Fire LLC · Missoula, MTBuilt 1990 · S/N 86-1682 N948CHHeligroup Fire LLC · Missoula, MTBuilt 1990 · S/N 90-0202 N949CHHeligroup Fire LLC · Missoula, MTBuilt 1990 · S/N 90-0205 N950CHConstruction Helicopters LLC · Howell, MIBuilt 1993 · S/N 93-0932 N952CHConstruction Helicopters LLC · Howell, MIBuilt 1992 · S/N 92-0307

Back to AD 2018-16-11