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.

N365LRegistered aircraftBuilt 2009 · S/N 20271 N365MGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2018 · S/N 20771 N369LLStrategic Leasing LLC · Seattle, WABuilt 2019 · S/N 20824 N370DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20056 N370ELLge Management Partners LLC · Phoenix, AZBuilt 2013 · S/N 20399 N371DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20064 N371JGNih-Aviation LLC · Charlotte, NCBuilt 2012 · S/N 20371 N371JLLink Snacks Inc · Minong, WIBuilt 2024 · S/N 21037 N372DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20055 N373DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20057 N374ABHat Trick Air LLC · Memphis, TNBuilt 2025 · S/N 21082 N375ABHat Trick Air LLC · Memphis, TNBuilt 2025 · S/N 21098 N376ABBombardier Aerospace Corp · Dallas, TXS/N 21128 N377DPOrr Investments LLC · Casper, WYBuilt 2012 · S/N 20377 N377MDCambria Aviation LLC · Belle Plaine, MNBuilt 2007 · S/N 20149 N377RUCmmr Enterprise LLC · Round Top, TXBuilt 2009 · S/N 20263 N379TFSaturdays Child LLC · Palm Beach Gardens, FLBuilt 2011 · S/N 20340 N37FEFederal Express Leasing Corp · Memphis, TNBuilt 2013 · S/N 20411 N383LAGh Development Holdings LLC · Salem, ORBuilt 2006 · S/N 20098 N385DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20041 N389PSRegistered aircraftN-number assigned (import), not yet registeredS/N 21151 N390JSFe Jetshare 1 LLC · Kinston, NCBuilt 2016 · S/N 20620 N391BDTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2015 · S/N 20599 N391JSOrlando Health Inc · Kinston, NCBuilt 2018 · S/N 20736 N392BDTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2014 · S/N 20522 N393JSG5 Aviation LLC · Miami, FLBuilt 2009 · S/N 20282 N394BWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 20394 N394JSJsv Aviation Ventures 703 LLC · Dallas, TXBuilt 2018 · S/N 20734 N395PDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 20577 N396BCAircat LLC · North Hollywood, CABuilt 2006 · S/N 20108 N396JSPh300 Holdings LLC · Wilmington, DEBuilt 2014 · S/N 20445 N396PDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 20532 N3975APcsa 1 LLC · Aspen, COBuilt 2007 · S/N 20170 N397JSCd 321 LLC · Austin, TXBuilt 2014 · S/N 20520 N398JSCd 321 LLC · Austin, TXBuilt 2018 · S/N 20726 N39FEFedex Freight Inc · Memphis, TNBuilt 2013 · S/N 20412 N3ASShamrock Foods Co · Phoenix, AZBuilt 2024 · S/N 21030 N402DBCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20118 N402HPGottsch Brothers Of Elkhorn LLC · Elkhorn, NEBuilt 2012 · S/N 20349 N404GRTonic Air Inc · Atlanta, GABuilt 2025 · S/N 21060 N404MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 21013 N405HMSky Air LLC · Norman, OKBuilt 2005 · S/N 20060 N406BJWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 20343 N408MJSnowair LLC · Twin Bridges, MTBuilt 2022 · S/N 20919 N409MRRegistered aircraftBuilt 2006 · S/N 20105 N40LGHilton Resorts Corp · Orlando, FLBuilt 2018 · S/N 20758 N411STTsmc Leasing LLC · Baton Rouge, LABuilt 2014 · S/N 20509 N412DLPnc Financial Services Group Inc · Pittsburgh, PABuilt 2024 · S/N 20990 N413GGClyde Enterprises LLC · Greenville, NCBuilt 2014 · S/N 20524 N414DHEos Leasing LLC · Saint Petersburg, FLS/N 20781

Back to AD 2017-17-13