Registered aircraft · 220

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

N234KQOld Beauty LLC · Missoula, MTS/N 100-0234 N239KQIdaho Transportation Department · Boise, IDS/N 100-0239 N23EGN254tg LLC · Cedar City, UTBuilt 2010 · S/N 100-0044 N242KQTeton Leasing LLC · Pocatello, IDBuilt 2018 · S/N 100-0242 N247TCTown & Country Aviation LLC · Sunnyvale, CABuilt 2009 · S/N 100-0025 N24MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 2024 · S/N 100-0348 N250DHKodiak Aircraft Co Inc · Sandpoint, IDS/N 100-0374 N252KInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 100-0109 N256PGDpa LLC · Coeur D Alene, IDBuilt 2018 · S/N 100-0256 N264DKStonewall Aviation LLC · Murfreesboro, TNBuilt 2019 · S/N 100-0264 N265KQRyffel Aviation LLC · Fort Worth, TXBuilt 2019 · S/N 100-0265 N267KQFp Winters LLC · Newark, DEBuilt 2019 · S/N 100-0267 N269MVMavi8 LLC · Sedona, AZFirst renewal noticeBuilt 2015 · S/N 100-0148 N279KQLmg-Rba LLC · Georgetown, TXBuilt 2019 · S/N 100-0279 N287JJA L S A P Enterprises LLC · Missoula, MTBuilt 2020 · S/N 100-0287 N28NRJaars Inc · Waxhaw, NCBuilt 2009 · S/N 100-0024 N2904GMec Aviation Kodiak LLC · Gainesville, GABuilt 2020 · S/N 100-0290 N292KQNortheast Elite Aviation LLC · Oakland, MEBuilt 2013 · S/N 100-0092 N293KDKodiak Special LLC · Huntsville, ALBuilt 2021 · S/N 100-0293 N297KDAir Sansone LLC · New Castle, DEBuilt 2021 · S/N 100-0297 N298FBFicek Mark · Hayden, IDS/N 100-0329 N298KDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 100-0298 N307RWRomeo Whiskey LLC · Klamath Falls, ORBuilt 2017 · S/N 100-0230 N307YPVillages Equipment Co · Leesburg, FLBuilt 2024 · S/N 100-0340 N309CQFelicidad Holdings LLC · Winter Springs, FLBuilt 2018 · S/N 100-0260 N309LTLebeouf Bros Towing LLC · Bourg, LABuilt 2021 · S/N 100-0294 N311KDTriple C Charters LLC · Carmel, INBuilt 2022 · S/N 100-0311 N312SBSwitchback Aviation LLC · Roscoe, MTBuilt 2022 · S/N 100-0309 N3140MObsidian Leasing LLC · Lehi, UTS/N 100-0326 N317XTN317xt LLC · Henderson, NVBuilt 2022 · S/N 100-0317 N31JA100-042 LLC · Menlo Park, CABuilt 2010 · S/N 100-0042 N320N320 LLC · North Las Vegas, NVBuilt 2023 · S/N 100-0328 N321N321 LLC · North Las Vegas, NVBuilt 2021 · S/N 100-0299 N322N322 LLC · North Las Vegas, NVBuilt 2019 · S/N 100-0273 N324KDGasmire David C · Fredericksburg, TXS/N 100-0324 N333KKHocken Brett Trustee · Lake Oswego, ORBuilt 2013 · S/N 100-0084 N338MCMissouri Department Of Conservation · Jefferson City, MOBuilt 2023 · S/N 100-0334 N339GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 100-0339 N33VACommonwealth Of Virginia · North Chesterfield, VABuilt 2025 · S/N 100-0351 N349WTPcw Air LLC · Mystic, CTBuilt 2024 · S/N 100-0349 N352CLMinam River Ranch LLC · Portland, ORBuilt 2018 · S/N 100-0253 N355KAGlobal Transport Ten LLC · Fort Myers, FLBuilt 2025 · S/N 100-0355 N355MBMio LLC · Satellite Beach, FLBuilt 2018 · S/N 100-0247 N356BMfsr LLC · Rigby, IDBuilt 2015 · S/N 100-0152 N365DHKodiak Aircraft Co Inc · Sandpoint, IDBuilt 2026 · S/N 100-0365 N366KAPelican Equipment LLC · New York, NYBuilt 2026 · S/N 100-0366 N367KAKodiak Aircraft Co Inc · Sandpoint, IDBuilt 2026 · S/N 100-0367 N3691DKodiak Aircraft Co Inc · Sandpoint, IDS/N 100-0369 N370KAMuncie Aviation Co · Muncie, INS/N 100-0370 N373KATvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2026 · S/N 100-0373

Back to AD 2016-06-06