Skip to content

Registered aircraft · 883

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-17-13') 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-17-13') 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-17-13')
    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-17-13')
  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-17-13')
  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-17-13')
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.

N312EAAea Services LLC · Delray Beach, FLBuilt 2023 · S/N 20943 N312HCUS Bank Na Trustee · Hartford, CTBuilt 2021 · S/N 20880 N313DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20183 N313VClyde Companies Inc · Orem, UTBuilt 2012 · S/N 20365 N314JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20100 N315JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20030 N316CSCaroler 316 LLC · Solon, OHBuilt 2007 · S/N 20180 N316KCorporate Jet Leasing Company LLC · Wichita, KSS/N 20765 N317VBVictor Bravo Air LLC · Dallas, TXS/N 20234 N318CMCarter Aviation LLC · Salem, VABuilt 2016 · S/N 20661 N31CAHf Sinclair Payroll Services Inc · Dallas, TXBuilt 2004 · S/N 20021 N31TFN31tf LLC · Machesney Park, ILBuilt 2015 · S/N 20547 N320JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20155 N320KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20594 N320LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 20417 N325PEPeco Air LLC · Park City, UTBuilt 2015 · S/N 20409 N325TGFlying G Aviation LLC · Atlanta, GABuilt 2014 · S/N 20455 N325WJDorado Aircraft Leasing LLC · Jupiter, FLBuilt 2014 · S/N 20449 N326HKGrand Fitness Miramar LLC · Destin, FLS/N 20697 N328RSHolloman Ventures Aviation LLC · Houston, TXBuilt 2012 · S/N 20382 N330PJKhcl LLC · Cincinnati, OHBuilt 2006 · S/N 20102 N330SAThree Feathers Logistics LLC · Atlanta, GABuilt 2013 · S/N 20413 N330ZAMead Gregory Zane · Lubbock, TXBuilt 2004 · S/N 20035 N3337JBig Horns Leasing LLC · Jackson, WYBuilt 2011 · S/N 20337 N334AFSusieair LLC · Houston, TXBuilt 2012 · S/N 20359 N334JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20334 N335AFArcadia Leasing LLC · Arcadia, WIS/N 20190 N335FGN335fg LLC · Urbana, ILBuilt 2023 · S/N 20974 N335REProampac Logistics LLC · North Hampton, NHBuilt 2020 · S/N 20858 N338JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20091 N339BVAljobe Bajeky LLC · Levittown, NYBuilt 2011 · S/N 20328 N339CMMmr West LLC · Salem, ORBuilt 2023 · S/N 20940 N339TBJkdb Air LLC · Beaumont, TXBuilt 2018 · S/N 20743 N33CHRitz Air LLC · Dayton, OHBuilt 2004 · S/N 20033 N340JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 20109 N343JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 20518 N345HGAxios Aviation LLC · Traverse City, MIBuilt 2013 · S/N 20431 N347FZZones Aircraft Leasing LLC · Bellevue, WABuilt 2017 · S/N 20681 N347KKiewit Engineering Group Inc · Omaha, NEBuilt 2008 · S/N 20240 N348BABillion Air LLC · Sioux Falls, SDBuilt 2019 · S/N 20782 N349KKiewit Engineering Group Inc · Omaha, NEBuilt 2023 · S/N 20959 N3500HBombardier Aerospace Corp · Dallas, TXS/N 21130 N350AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 20733 N350ATRmf Horizon LLC · Syracuse, NYBuilt 2019 · S/N 20795 N350CKSilver Britches Air LLC · Athens, GABuilt 2019 · S/N 20804 N350CLGlobal Flight Inc · Wichita, KSS/N 21086 N350CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 20525 N350HHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 20760 N350HJLr60 296 Florida Holdings Inc · Coral Gables, FLBuilt 2014 · S/N 20504 N350JBBank Of Utah Trustee · Salt Lake City, UTS/N 21116

Back to AD 2017-17-13