Registered aircraft · 5,537

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:2012-26-15-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-15-R1') 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:2012-26-15-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-15-R1')
  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:2012-26-15-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-15-R1')
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.

N553HADepartment Of Defense Missile Defense Agency · Tulsa, OKBuilt 2010 · S/N 5290 N553RDBristow LLC · Lake Charles, LABuilt 2014 · S/N 41369 N553SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5575 N553SXUmb Bank Na Trustee · Salt Lake City, UTS/N 3171 N553UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4960 N554DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 5196 N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898 N554NGRtvh III LLC · Gila Bend, AZBuilt 2015 · S/N 1554 N554SNTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 5604 N554UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4966 N554VAAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 234 N554WABravo Zulu Pilatus N554wa LLC · Portage, MIBuilt 2017 · S/N 1685 N555GSInvestjet LLC · Miami, FLBuilt 2001 · S/N 149 N555KBPocket Water Aviation LLC · Belmont, CABuilt 2024 · S/N 2380 N555KHRegian Services LLC · Encino, CABuilt 2009 · S/N 5237 N555MEMansfield Aviation LLC · Gainesville, GABuilt 2024 · S/N 2382 N555PHPhqp Leasing LLC · Roswell, GABuilt 2017 · S/N 1683 N555VRTrego/Dugan Aviation Inc · North Platte, NEBuilt 2004 · S/N 257 N555WZHi Tequity Air Holdings Spv LLC · Melbourne Beach, FLBuilt 2004 · S/N 560-5366 N5569Landmark Graphics Corp · Houston, TXBuilt 2007 · S/N 5169 N556BHBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 57556 N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904 N556LSCharlie Brown Air III LLC · Boca Raton, FLBuilt 2002 · S/N 560-5276 N556UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5244 N556WFClearair LLC · Taylorsville, NCBuilt 1999 · S/N 560-5024 N557AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5057 N557BHBell Textron Inc · Fort Worth, TXBuilt 2026 · S/N 57558 N557LMCorsair Two LLC · Hillsboro, ORBuilt 2008 · S/N 379 N557SPU S Bank Na · Marshall, MNBuilt 2016 · S/N 531 N557UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5269 N5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5085 N558APLmc Leasing LLC · Tallahassee, FLBuilt 2009 · S/N 4159 N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915 N558LMCorsair Two LLC · Hillsboro, ORBuilt 2006 · S/N 312 N558SPUS Bank Na · Marshall, MNBuilt 2016 · S/N 551 N558UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5282 N559DHDhv Pc12 LLC · Haverhill, FLBuilt 2010 · S/N 1233 N559DWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5110 N559GGlen Alba Investments Inc Trustee · Wilmington, DEBuilt 2003 · S/N 5012 N559HFAlmond Co · Madera, CABuilt 2016 · S/N 560-6213 N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917 N559LMCorsair Two LLC · Hillsboro, ORBuilt 2005 · S/N 286 N559UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5292 N55DWCc Aviation LLC · Hastings, NEBuilt 2016 · S/N 1624 N55GXSunset Mission 888 LLC · Kansas City, MOBuilt 2020 · S/N 2012 N55QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2014 · S/N 5495 N55VWVariety Wholesalers Inc · Henderson, NCBuilt 2000 · S/N 560-5076 N560ADAir Direct LLC · Powderly, TXBuilt 2002 · S/N 560-5239 N560APSouthern Capital Air LLC · Atlanta, GABuilt 2007 · S/N 560-5707 N560ARBrook Haven Properties LLC · Camden, DEFirst renewal noticeS/N 560-6026

Back to AD 2012-26-15 R1