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.

N418CLNnumber LLC · Wilmington, DEBuilt 2000 · S/N 130 N418LACernicalo Leasing LLC · Wilmington, DEBuilt 2005 · S/N 34246 N418TFish Hawk Air LLC · Ogden, UTBuilt 2019 · S/N 1891 N419AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26913 N419LGAero Jet Aviation I Inc · Fort Lauderdale, FLS/N 079 N41NERock Air LLC · Lititz, PABuilt 2024 · S/N 2364 N41PMSouthland Holding Group LLC · Beverly Hills, CABuilt 2007 · S/N 5177 N41PRDk Air LLC · Scottsdale, AZBuilt 2003 · S/N 560-5325 N41UARazorback Foundation Inc · Fayetteville, ARBuilt 2007 · S/N 45-2074 N420CCCooke & Cooke Air LLC · Nashville, TNBuilt 1996 · S/N 40 N420DGDg + Ag LLC · Albuquerque, NMBuilt 2011 · S/N 1284 N420DLPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 2002 · S/N 560-5266 N420GX396rf LLC · Muncie, INBuilt 2020 · S/N 2018 N420LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 34627 N421LTSj Transportation Holdings LLC · San Angelo, TXBuilt 2004 · S/N 560-5370 N421PKLightning Leasing LLC · Horseshoe Bay, TXBuilt 2024 · S/N 2400 N421PPBbb Air LLC · Dallas, TXS/N 1010 N421QSRegistered aircraftBuilt 2008 · S/N 4114 N422AVUmb Bank N A Trustee · Salt Lake City, UTBuilt 2010 · S/N 4200 N422JBGivens Aw Lc · Chesapeake, VABuilt 2015 · S/N 1514 N422JRAtkinson Aviation LLC DBA · Chatham, VABuilt 2018 · S/N 1766 N423AXOmni Planes LLC · Tulsa, OKBuilt 1996 · S/N 27569 N423KTRyan Exploration Inc · Englewood, COBuilt 2014 · S/N 1501 N423SASanstone Management Company LLC · Arden, NCBuilt 2022 · S/N 2227 N424EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5234 N424PJHelibro LLC · Red Bluff, CABuilt 2012 · S/N 57113 N424PXNf Air Ventures LLC · Southfield, MIBuilt 2007 · S/N 4101 N424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 169 N425MSweeney Holding Voyager LLC · Leander, TXBuilt 2008 · S/N 366 N425TMIntellectual Air LLC · Atlanta, GABuilt 2008 · S/N 5191 N426AVAircol 10 · Wilmington, DEBuilt 2009 · S/N 4026 N426CHCalhoun Transport LLC · Minneapolis, MNBuilt 2002 · S/N 560-5222 N426PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 57057 N426SASuperior Ambulance Aviation Inc · Elmhurst, ILBuilt 2011 · S/N 426 N426UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 510 N427DLEmij LLC · Naples, FLBuilt 2006 · S/N 560-5622 N427MMDavjon Leasing LLC · Rogers, MNBuilt 2009 · S/N 560-6009 N427PMSunnyside Aviation LLC · Jacksonville, FLBuilt 2009 · S/N 560-6052 N427UAUnited Airlines Inc · Chicago, ILFirst renewal noticeBuilt 1995 · S/N 512 N428CFCareflite · Grand Prairie, TXBuilt 2014 · S/N 57228 N428NELeonardo Helicopters US Corp · Philadelphia, PABuilt 2007 · S/N 41001 N428UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 523 N429ARAbfd LLC · Deerfield Beach, FLBuilt 2020 · S/N 57411 N429ASWest States Leasing Inc · Medford, ORS/N 57142 N429AXBell Textron Inc · Fort Worth, TXBuilt 2012 · S/N 57081 N429BFCustomers Commercial Finance LLC · Portsmouth, NHBuilt 2023 · S/N 57478 N429BHBell Textron Inc · Fort Worth, TXBuilt 2010 · S/N 57005 N429CBLina 1 LLC · Nashville, TNBuilt 2012 · S/N 57099 N429CFCareflite · Grand Prairie, TXBuilt 2013 · S/N 57128 N429CHVentus Mf LLC · Boise, IDBuilt 2010 · S/N 57014

Back to AD 2012-26-15 R1