Registered aircraft · 76

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:2004-05-01-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:2004-05-01-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:2004-05-01-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:2004-05-01-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:2004-05-01-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:2004-05-01-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.

N709KAKenmore Air Harbor LLC · Kenmore, WABuilt 1960 · S/N 410 N722FHEmerald Air Services Inc · Homer, AKBuilt 1961 · S/N 429 N724FHEmerald Air Service Inc · Homer, AKBuilt 1958 · S/N 267 N727FHEmerald Air Service Inc · Homer, AKBuilt 1958 · S/N 307 N727KTRustair Inc · Anchorage, AKBuilt 1961 · S/N 419 N753AKDh Leasing LLC · Juneau, AKBuilt 1953 · S/N 007 N75GEGolden Eagle Outfitters Inc · Delta Junction, AKS/N 90 N765KAKenmore Air Harbor LLC · Kenmore, WABuilt 1953 · S/N 26 N76KAKenmore Air Harbor LLC · Kenmore, WABuilt 1958 · S/N 300 N775THGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1955 · S/N 75 N80945Talkeetna Air Taxi Inc · Talkeetna, AKBuilt 1959 · S/N 385 N838KTRust Air Inc · Anchorage, AKS/N 329 N859WDJb Leasing Co LLC · Kenai, AKS/N 16 N859XDJb Leasing Co LLC · Kenai, AKS/N 65 N859YHJb Leasing Co LLC · Kenai, AKS/N 399 N87AWSummit Leasing LLC · Kenai, AKBuilt 1954 · S/N 52 N87KAKenmore Air Harbor LLC · Kenmore, WABuilt 1953 · S/N 11 N88765Talkeetna Air Taxi Inc · Talkeetna, AKBuilt 1956 · S/N 157 N90422Kenmore Air Harbor LLC · Kenmore, WABuilt 1955 · S/N 152 N90758Hayton James B · Sedro Woolley, WAS/N 455 N9225Jb Leasing Company LLC · Kenai, AKS/N 373 N92858Blue Aircraft LLC · Ketchikan, AKBuilt 1953 · S/N 8 N929KTRustair Inc · Anchorage, AKBuilt 1965 · S/N 461 N93356Red Leasing LLC · Juneau, AKBuilt 1955 · S/N 144 N947RKRegistration Pending · Roseburg, ORRegistration pendingBuilt 1955 · S/N 77 N98TSolberg Douglas G · Juneau, AKBuilt 1956 · S/N 181

Back to AD 2004-05-01 R1