Skip to content

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.

N100AMBoundless Blue LLC · Scottsdale, AZBuilt 2018 · S/N 100-0259 N100KNRak Kodiak LLC · Middletown, DEBuilt 2018 · S/N 100-0257 N101AKPacific Diversified Investments Inc · Anchorage, AKBuilt 2025 · S/N 100-0356 N101KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 100-0101 N102KQAogline.Com Inc · Fullerton, CAS/N 100-0102 N107KQJsc Rentals LLC · Missoula, MTBuilt 2014 · S/N 100-0107 N109WTJe Kodiak 2018 LLC · Edina, MNBuilt 2018 · S/N 100-0246 N112KQRondarosa Skybus LLC · Grangeville, IDBuilt 2014 · S/N 100-0112 N117EGFcs Aircraft Inc Trustee · Wilmington, DEBuilt 2014 · S/N 100-0117 N120KQMission Aviation Fellowship · Nampa, IDBuilt 2014 · S/N 100-0120 N123KQValiair Lc Trustee · Casper, WYBuilt 2009 · S/N 100-0013 N125ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0226 N12MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 2024 · S/N 100-0342 N12MYInternational Air Services Inc Trustee · Carson City, NVS/N 100-0062 N1322TStrain Aviation LLC · Arbuckle, CABuilt 2015 · S/N 100-0135 N133KQValiair Lc Trustee · Casper, WYBuilt 2014 · S/N 100-0133 N142DVSalerno Robert J · Cornwall, NYBuilt 2015 · S/N 100-0142 N14RPAs350 LLC · Missoula, MTBuilt 2024 · S/N 100-0338 N150KReilly John P · Friendsville, PABuilt 2011 · S/N 100-0051 N151BCBrc Az Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 100-0289 N154NPSisk Douglass F Trustee · Oakhurst, CABuilt 2019 · S/N 100-0262 N155KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 100-0155 N157CLSnowy Butte Air Ships LLC · Eagle Point, ORBuilt 2015 · S/N 100-0157 N158KQGuardian Angel Homes LLC · Hayden, IDBuilt 2015 · S/N 100-0158 N160KQMjolhus Knut G · Amarillo, TXBuilt 2015 · S/N 100-0160 N160ZUsda Forest Service · Boise, IDBuilt 2017 · S/N 100-0227 N161KQPenridge Aviation LLC · Portland, ORBuilt 2015 · S/N 100-0161 N167ZUsda Forest Service Fire And Aviation · Boise, IDBuilt 2025 · S/N 100-0361 N180MRState Of Maine Dept Of Marine Resources · Augusta, MEBuilt 2024 · S/N 100-0341 N182KQSnl Aviation LLC · Seattle, WABuilt 2016 · S/N 100-0182 N18BTT5 Capital Partners LLC · Dallas, TXBuilt 2021 · S/N 100-0302 N1927SBlue Sky Assets LLC · Garden Valley, IDBuilt 2015 · S/N 100-0136 N1928S1928 LLC · Salmon, IDBuilt 2023 · S/N 100-0331 N192KQShort Field Partners LLC · Bend, ORBuilt 2016 · S/N 100-0192 N193KQAmerican O-Zones LLC · Tavernier, FLBuilt 2016 · S/N 100-0193 N199KQBridger Aviation Services LLC · Belgrade, MTBuilt 2016 · S/N 100-0199 N200KQBridger Aviation Services LLC · Belgrade, MTBuilt 2016 · S/N 100-0200 N203KQBridger Aviation Services LLC · Belgrade, MTBuilt 2017 · S/N 100-0203 N206KQDc3 Properties LLC · Sacramento, CABuilt 2017 · S/N 100-0206 N207KQArizona Game And Fish Department · Phoenix, AZBuilt 2017 · S/N 100-0207 N210VACommonwealth Of Virginia · North Chesterfield, VABuilt 2025 · S/N 100-0353 N211CRRegistered aircraftS/N 100-0027 N211MAvp Aviation LLC · Indianapolis, INBuilt 2017 · S/N 100-0211 N216KQState Of Washington · Olympia, WABuilt 2017 · S/N 100-0216 N220QKBridger Aviation Services LLC · Belgrade, MTBuilt 2017 · S/N 100-0220 N222HHJenntoo LLC · Wilmington, DEBuilt 2022 · S/N 100-0314 N223QKRovey Jason · Wickenburg, AZBuilt 2017 · S/N 100-0223 N228VJAyfu LLC · Kalispell, MTBuilt 2022 · S/N 100-0306 N229CLMcknight Thomas N · Fredericksburg, TXBuilt 2017 · S/N 100-0229 N233KQImagine Air Leasing LLC · Fort Lauderdale, FLBuilt 2017 · S/N 100-0233

Back to AD 2016-06-06