Registered aircraft · 21

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

N143NENew England Life Flight Inc DBA · Bedford, MABuilt 2018 · S/N 20218 N145DVLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 2016 · S/N 20117 N145HMA7p Trust Co Inc Trustee · Cheyenne, WYBuilt 2017 · S/N 20132 N343PHPhi Aviation LLC · Lafayette, LABuilt 2017 · S/N 20120 N366GTGth & Tth Holdings LLC · Redwood City, CABuilt 2018 · S/N 20216 N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227 N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239 N377AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 20254 N378AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 20260 N379AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 20263 N393PHPhi Aviation LLC · Lafayette, LABuilt 2017 · S/N 20122 N605AVAvera Mckennan · Sioux Falls, SDBuilt 2017 · S/N 20153 N607SPNew Mexico State Police Aircraft Section · Santa Fe, NMBuilt 2018 · S/N 20174 N619GESan Diego Gas & Electric Co · San Diego, CABuilt 2017 · S/N 20156 N695HSMocha LLC · Tucson, AZBuilt 2016 · S/N 20047 N702LFLonian Raven LLC · Wilmington, DEBuilt 2018 · S/N 20210 N843LFLife Flight Network LLC · Aurora, ORBuilt 2018 · S/N 20219 N8KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 20353 N945DCJs Leasing LLC · Frisco, TXBuilt 2015 · S/N 20059 N954KHWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 20287 N995RCCounty Of Riverside California · Hemet, CABuilt 2019 · S/N 20280

Back to AD 2017-07-08