OpenAirDocs.org
AD 2017-17-13

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
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.

N960CRVillage Transport Corp · Richmond Heights, OHBuilt 2019 · S/N 20787N960GRHorizons Equity Enterprises LLC · Orchard Park, NYBuilt 2005 · S/N 20080N962HCHytrol Conveyor Company Inc · Jonesboro, ARBuilt 2025 · S/N 21049N963HBombardier Aerospace Corp · Dallas, TXS/N 21140N967JBEverbank Na · Chicago, ILBuilt 2025 · S/N 21058N969AFFalcon Field Services LLC · Casper, WYBuilt 2013 · S/N 20392N96HMPnc Bank Na · Boise, IDBuilt 2021 · S/N 20885N971MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20126N971WHDrt LLC · Carter Lake, IABuilt 2023 · S/N 20971N972SCUS Bank Na Trustee · Hartford, CTBuilt 2021 · S/N 20888N973JBRegistered aircraftN-number assigned (import), not yet registeredS/N 21162N978SHSh978 LLC · Atherton, CABuilt 2017 · S/N 20719N979CSWilmington Trust Co Trustee · Wilmington, DES/N 20898N979KCCharlotte Logistics LLC · Sacramento, CABuilt 2016 · S/N 20610N979WMRegistered aircraftBuilt 2009 · S/N 20254N97DKJourney & Home Inc · Philadelphia, PABuilt 2008 · S/N 20216N97SHWest Ridge Air II LLC · Charlottesville, VABuilt 2013 · S/N 20401N985KMJfm Aviation LLC · Raleigh, NCBuilt 2006 · S/N 20134N988DWRaven Aviation LLC · Fresno, CABuilt 2010 · S/N 20306N988RTAspen Austin Air LLC · Fredericksburg, TXBuilt 2013 · S/N 20427N98ECEntergy Services LLC · New Orleans, LABuilt 2018 · S/N 20772N990JCFhi LLC · Fuquay Varina, NCBuilt 2013 · S/N 20421N992DCJwj Leasing LLC · Frisco, TXBuilt 2013 · S/N 20423N993JLSonora Trophy Hunts LLC · San Angelo, TXBuilt 2018 · S/N 20756N993TBAdams Steel Of Nevada Inc · Fort Lauderdale, FLBuilt 2011 · S/N 20312N995CBAllsups LLC · Clovis, NMBuilt 2016 · S/N 20619N995RRRayfield Aviation LLC · West Palm Beach, FLBuilt 2024 · S/N 21029N997WCWaste Connections US Inc · The Woodlands, TXBuilt 2009 · S/N 20269N998GGershow LLC · Medford, NYBuilt 2018 · S/N 20751N999NDFriends In The Skies LLC · Dallas, TXBuilt 2008 · S/N 20250N999VRLagniappe Equipment LLC · Dover, DEBuilt 2006 · S/N 20110N99MRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 20450N9JAJuniper Aviation IV LLC · Coral Gables, FLS/N 20295
Back to AD 2017-17-13