Registered aircraft · 5,538

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.

N312NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2289 N312PMGretchen LLC · Boise, IDBuilt 2020 · S/N 2044 N3131A313 Aviation Holdings LLC · Miami Beach, FLBuilt 2003 · S/N 5021 N313AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24930 N313DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7381 N313FTUmb Bank Na Trustee · Salt Lake City, UTS/N 2313 N313GXSilver Britches Air II LLC · Wilmington, DEBuilt 2021 · S/N 2106 N313NGPwc Aviation LLC · Omaha, NEBuilt 2011 · S/N 1313 N313NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2300 N314CWR & B Aviation LLC · Columbia, MOBuilt 2025 · S/N 560-6504 N314DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7281 N314NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1191 N314SJHrm Aviation LLC · Chesterfield, MOBuilt 1992 · S/N 115 N314TPTutor Perini Corporation · Sylmar, CABuilt 2006 · S/N 5104 N315DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 7436 N315NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1230 N315NGIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2011 · S/N 1315 N315NVSunrise Asset Management LLC · Las Vegas, NVS/N 2412 N315PCPapa Charlie LLC · Provo, UTS/N 2179 N316CJNovember 316 LLC · Caldwell, WVBuilt 2008 · S/N 359 N316DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7327 N316EWEdson LLC · San Angelo, TXBuilt 2011 · S/N 1318 N316GNGeneral Industries LLC · Camden, NJBuilt 2012 · S/N 5389 N316NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1249 N316NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2481 N316SWLongfellow An LLC · Dallas, TXS/N 1680 N316VAAvation LLC · Grand Rapids, MIBuilt 2015 · S/N 5530 N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445 N317CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24317 N317CWWilson Eric · San Angelo, TXBuilt 2022 · S/N 2184 N317DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 7373 N317DTN42nh LLC · Oklahoma City, OKBuilt 1994 · S/N 04 N317GRBell Textron Inc · Fort Worth, TXS/N 57564 N317GSGolden Shamrock Associates LLC · Wilmington, DES/N 178 N317MNext Level Marine LLC · Mount Pleasant, TXBuilt 2002 · S/N 188 N317MCMgl Equipment LLC · Omaha, NEBuilt 2008 · S/N 380 N317NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1324 N317PJCl30 LLC · Bethany, OKBuilt 2007 · S/N 14501007 N318DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 4229 N318DXDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 7441 N318GRBell Textron Inc · Fort Worth, TXS/N 57567 N318MMPerfect Agreement Leasing Inc · Trabuco Canyon, CABuilt 2001 · S/N 560-5220 N318NBDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 1325 N318NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 2492 N318SAOtm Equipment LLC · West Lake Hills, TXBuilt 2000 · S/N 114 N318XLCarriage Dpb LLC · Gainesville, GABuilt 2022 · S/N 560-6318 N319CMCargo Aircraft Management Inc · Wilmington, OHS/N 24407 N319CRKangaruby LLC · Wilmington, DEBuilt 2009 · S/N 5260 N319DNDelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 2017 · S/N 7479 N319FSBanc Of California · Chicago, ILBuilt 2020 · S/N 5621

Back to AD 2012-26-15 R1