Registered aircraft · 28

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

N113PWBigfoot Aviation LLC · Kalispell, MTS/N 2106 N195FWMoab Ballooning LLC · Moab, UTBuilt 2011 · S/N 858 N228JAir Carriage LLC · San Marcos, TXS/N 1573 N243TWRocky Mountain Balloon Adventures LLC · Pagosa Springs, COBuilt 2023 · S/N 2151 N275BNTahoe Balloon Tours · Gardnerville, NVBuilt 2024 · S/N 2317 N275FBWilkinson Steve A · Lake Havasu City, AZBuilt 2021 · S/N 1875 N275NSNapa Valley Aloft Inc · Yountville, CAS/N 1363 N275SLPacific Rim Adventures Inc · Los Olivos, CABuilt 2022 · S/N 1991 N275YVNapa Valley Aloft Inc · Yountville, CABuilt 2019 · S/N 1582 N278RRRainbow Ryders Inc · Albuquerque, NMBuilt 2023 · S/N 2127 N300EAEscape Adventures Inc · Temecula, CABuilt 2021 · S/N 1912 N300GEEscape Adventures Inc · Temecula, CABuilt 2017 · S/N 1329 N300NSNapa Valley Aloft Inc · Yountville, CABuilt 2014 · S/N 1109 N300YVNapa Valley Aloft Inc · Yountville, CABuilt 2022 · S/N 1925 N301SBSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2022 · S/N 1918 N310SBSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2022 · S/N 2038 N320SBSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2022 · S/N 2075 N325KBAbove Reality Inc · Jericho, VTBuilt 2023 · S/N 2089 N325PVNapa Valley Aloft Inc · Napa, CABuilt 2024 · S/N 2261 N325YVNapa Valley Aloft Inc · Napa, CABuilt 2024 · S/N 2260 N460JRegistered aircraftBuilt 2023 · S/N 2121 N4961DDistrict Aviation LLC · Eloy, AZBuilt 2011 · S/N 851 N5610CSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2011 · S/N 872 N6128BAir Carriage LLC · Albuquerque, NMBuilt 2018 · S/N 1415 N72866Castellion Jack A · Winter Park, COBuilt 2019 · S/N 1564 N7647NRohr Balloons LLC · Lucas, TXBuilt 2024 · S/N 2290 N917PRPortland Rose Balloons LLC · Wilsonville, ORBuilt 2023 · S/N 2116 N962KBBarrett Dennis F · Temecula, CABuilt 2012 · S/N 959

Back to AD 2021-16-14