Registered aircraft · 878

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.

N100SAEssay Management Services LLC · Oklahoma City, OKBuilt 2024 · S/N 21019 N10131013sh LLC · Novato, CABuilt 2008 · S/N 20229 N102CECenterpoint Energy Service Co LLC · Houston, TXBuilt 2020 · S/N 20849 N108ETCarlisle LLC · Scottsdale, AZBuilt 2011 · S/N 20333 N10EHReh Finance Co · Salt Lake City, UTBuilt 2019 · S/N 20810 N10SERadair LLC · Memphis, TNBuilt 2023 · S/N 20973 N10UNGlobal Air LLC · Nashville, TNBuilt 2018 · S/N 20748 N1107MAsifd LLC · Dallas, TXBuilt 2005 · S/N 20039 N110MWRegistered aircraftBuilt 2024 · S/N 21001 N111EDBnp Holdings LLC · Lakewood Ranch, FLBuilt 2005 · S/N 20058 N111ELContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 20051 N115ADAmerican Promotional Events Inc · Florence, ALBuilt 2011 · S/N 20331 N115LFAirlynner LLC · Jackson, WYBuilt 2008 · S/N 20226 N115SEAdvanta Aviation 3500 LLC · La Jolla, CABuilt 2022 · S/N 20926 N116HFAirbourne International Inc · Wilmington, DEBuilt 2004 · S/N 20011 N118DBCitation X Parts LLC · Liberty, NCBuilt 2006 · S/N 20071 N119DTTennthom Aviation Corp · La Vergne, TNBuilt 2024 · S/N 20988 N11EFBlue Kestrel Operations LLC · Reno, NVS/N 20838 N120DRClo Equipment II LLC · Chicago, ILBuilt 2020 · S/N 20846 N120JBRegistered aircraftBuilt 2026 · S/N 21121 N120JCSouthwestern Jet Inc · Saint Louis, MOBuilt 2005 · S/N 20069 N1221JTurner Jim L · Dallas, TXBuilt 2012 · S/N 20364 N123JKLayven Air II LLC · Battlefield, MOBuilt 2007 · S/N 20142 N123QWilmington Trust Co Trustee · Wilmington, DEBuilt 2016 · S/N 20616 N126PHPam Aviation LLC · Enola, PABuilt 2013 · S/N 20435 N127EBForty Acres Aviation LLC · Wheeling, ILBuilt 2014 · S/N 20515 N12ECEntergy Services LLC · New Orleans, LABuilt 2017 · S/N 20717 N12FRegistered aircraftBuilt 2026 · S/N 21114 N1313ACasbj Air LLC · Miami, FLBuilt 2013 · S/N 20403 N131JRC&S Wholesale Grocers LLC · Keene, NHBuilt 2024 · S/N 21046 N131KRStr Holdings LLC · Memphis, TNBuilt 2020 · S/N 20855 N131KSRegistered aircraftBuilt 2006 · S/N 20092 N135CGCti Of North Carolina Inc · Wilmington, NCBuilt 2023 · S/N 20955 N136DBCitation X Parts LLC · Liberty, NCBuilt 2008 · S/N 20222 N140GSOne Gas Inc · Tulsa, OKBuilt 2025 · S/N 21059 N147WRegistered aircraftN-number assigned (import), not yet registeredS/N 21143 N148WRegistered aircraftN-number assigned (import), not yet registeredS/N 21150 N14FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 21074 N150MBW5 Equipment Leasing LLC · Saint Louis, MOBuilt 2007 · S/N 20166 N155SLSela Plane LLC · Houston, TXBuilt 2007 · S/N 20187 N156PHPg Square LLC · Cleveland, OHBuilt 2017 · S/N 20696 N157PH443a Aviation LLC · Traverse City, MIBuilt 2017 · S/N 20715 N158PHPg Square LLC · Cleveland, OHBuilt 2018 · S/N 20721 N159WHYas II (US) Mockingbird LLC · New York, NYBuilt 2004 · S/N 20017 N15GTTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2006 · S/N 20120 N15HDDdrh Holdings LLC · Helena, MTBuilt 2026 · S/N 21097 N15HR5r Aviation LLC · Tampa, FLBuilt 2005 · S/N 20072 N15NPRegistered aircraftBuilt 2022 · S/N 20909 N15RBAir Metro LLC · Lake Forest, ILBuilt 2010 · S/N 20277 N15TFTaylor Fresh Foods Inc · Salinas, CABuilt 2023 · S/N 20942

Back to AD 2017-17-13