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.

N567LPLearjet Flyer Inc Trustee · Cheyenne, WYBuilt 2008 · S/N 367 N567MCN63xp LLC · Brea, CABuilt 2003 · S/N 5605357 N567UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5728 N568GAGulfstream Aerospace Corp · Savannah, GABuilt 2019 · S/N 5608 N568JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2063 N568JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5340 N568LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 42214 N568LXLanier Equipment Leasing LLC · Gainesville, GABuilt 2007 · S/N 560-5680 N568QSNetjets Sales Inc · Columbus, OHBuilt 2008 · S/N 560-5829 N568UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5751 N569AZAmazon.Com Services LLC · Seattle, WAS/N 25246 N569JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2075 N569MKKam Air LLC · High Point, NCBuilt 1998 · S/N 560-5006 N56BUBsi Holdings LLC · Portland, ORBuilt 2004 · S/N 5059 N56CAusome Aviation LLC · Newark, DEBuilt 2012 · S/N 5396 N56CTTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 1817 N56HVHaley Timothy M · Palo Alto, CABuilt 2021 · S/N 2103 N56JPMed Air LLC · Lawrenceville, GABuilt 2001 · S/N 183 N56LEAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2004 · S/N 2021 N56NGSky Dweller LLC · Little Rock, ARBuilt 2015 · S/N 1556 N56WZAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 560-5156 N57016United Airlines Inc · Chicago, ILBuilt 2000 · S/N 28679 N570AMMann Aviation LLC · Broken Arrow, OKBuilt 2003 · S/N 238 N570JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2099 N570LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40799 N570MPMed Air LLC · Lawrenceville, GAS/N 171 N570P10201 Air LLC · Omaha, NEBuilt 2006 · S/N 560-5628 N570TABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3869 N571AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30388 N571BCInternational Bank Of Commerce · Oklahoma City, OKBuilt 1999 · S/N 560-5013 N571CBKba Bridges & Shields LLC · East Point, GABuilt 1984 · S/N 001 N571JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2125 N57265Louisiana State Police · Baton Rouge, LABuilt 2019 · S/N 1845 N572LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 41747 N572MRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 57207 N572UWAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5899 N573QSNetjets Sales Inc · Oklahoma City, OKFirst renewal noticeBuilt 2008 · S/N 560-5827 N573UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5939 N574FBFbr Aviation Inc · Fort Lauderdale, FLBuilt 2021 · S/N 57424 N574QSNetjets Sales Inc · Oklahoma City, OKBuilt 2008 · S/N 560-5820 N575HKwa Holdings LLC · Overland Park, KSBuilt 2020 · S/N 2037 N575QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5730 N575UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5980 N576QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5708 N576UWAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6027 N577NANasa Langley Research Center · Hampton, VAS/N 32892 N577PE1995 Holdings LLC · Thomasville, GABuilt 2015 · S/N 1577 N577PSPad One Holdings LLC · Wilmington, DEBuilt 2005 · S/N 560-5581 N577QSNetjets Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 560-5735 N577TABank Of Utah Trustee · Salt Lake City, UTS/N 355

Back to AD 2012-26-15 R1