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.

N160SBMedical Center Development LLC · Pleasanton, CABuilt 2009 · S/N 20293 N160WCWca Holdings II LLC · Missoula, MTBuilt 2010 · S/N 20305 N161DBCitation X Parts LLC · Liberty, NCBuilt 2010 · S/N 20302 N165RDIsland Park Aviation LLC · Fargo, NDBuilt 2018 · S/N 20745 N166WCWca Holdings I LLC · Missoula, MTBuilt 2008 · S/N 20214 N167FTFifth Third Bank Na · Cincinnati, OHBuilt 2015 · S/N 20559 N167RDIsland Park Aviation LLC · Fargo, NDBuilt 2012 · S/N 20363 N168GCElk Air Partners III LLC · Monroe, MIBuilt 2018 · S/N 20724 N170WCWca Holdings IV LLC · Missoula, MTBuilt 2016 · S/N 20645 N1721MBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 20143 N176WCWca Holdings IV LLC · Missoula, MTBuilt 2016 · S/N 20654 N179RP179 Rp LLC · Melrose Park, ILBuilt 2024 · S/N 21000 N17KUTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTS/N 20777 N17UCUnited Company · Bristol, VABuilt 2011 · S/N 20345 N1826KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20067 N184BKSla Aviation LLC · Wilmington, DEBuilt 2008 · S/N 20209 N186DBCitation X Parts LLC · Liberty, NCBuilt 2012 · S/N 20342 N1870EN1870g Leasing LLC · Fort Collins, COBuilt 2015 · S/N 20555 N188LTTls Aviation LLC · Tulsa, OKBuilt 2025 · S/N 21053 N188SFRegistered aircraftBuilt 2008 · S/N 20195 N1932SShehadey Enterprise Solutions LLC · Fresno, CABuilt 2011 · S/N 20318 N1933NNorthern Jet Management Inc · Grand Rapids, MIBuilt 2006 · S/N 20133 N194TDJones Air LLC · Mt Juliet, TNBuilt 2008 · S/N 20232 N1972HHl Aircraft LLC · Oklahoma City, OKBuilt 2024 · S/N 21033 N1980ZRegistered aircraftBuilt 2005 · S/N 20049 N1995PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21126 N1998CClyde Companies Inc · Orem, UTBuilt 2024 · S/N 20996 N1HPHelmerich & Payne Inc · Tulsa, OKBuilt 2012 · S/N 20362 N1MUMurphy Oil USA Inc · El Dorado, ARBuilt 2022 · S/N 20901 N1RBBac Transportation Inc · Stockton, CABuilt 2005 · S/N 20073 N1RCRegistered aircraftBuilt 2022 · S/N 20937 N1SGAir Sansone LLC · Wilmington, DEBuilt 2004 · S/N 20025 N200JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 20843 N200JCClo Equipment LLC · Chicago, ILBuilt 2019 · S/N 20791 N203CKMacs Aviation LLC · Columbus, INBuilt 2025 · S/N 21089 N205DBCitation X Parts LLC · Liberty, NCBuilt 2005 · S/N 20074 N206DBCitation X Parts LLC · Liberty, NCBuilt 2007 · S/N 20160 N206FPSeguin Holdings LLC · Chicago, ILBuilt 2008 · S/N 20220 N210DBCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20128 N211JBPiker LLC · Wheeling, ILBuilt 2012 · S/N 20353 N21381Hardwicke Properties LLC · Houston, TXBuilt 2018 · S/N 20774 N214RWMidwest Nas Inc · Onalaska, WIBuilt 2024 · S/N 21009 N214SGSnj Partners Eb5 Fund LLC · Mesquite, TXBuilt 2002 · S/N 20004 N215DAStravinski Development Group LLC · Madera, CABuilt 2010 · S/N 20304 N217SGGiddy Air LLC · Fredonia, NYBuilt 2025 · S/N 21093 N218KFKw Flight LLC · Bozeman, MTBuilt 2013 · S/N 20438 N21FEFedex Freight Inc · Memphis, TNBuilt 2012 · S/N 20352 N21FRFlying Fox LLC · Phoenix, AZBuilt 2018 · S/N 20747 N220FXJsa Investments LLC · Cleveland, OHBuilt 2025 · S/N 21075 N2218HRegistered aircraftBuilt 2025 · S/N 21081

Back to AD 2017-17-13