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.

N51CUUnited Bottling Management Company LLC · Birmingham, ALBuilt 2022 · S/N 560-6321 N51GSGeneral Shale Building Materials Inc · Johnson City, TNBuilt 2013 · S/N 466 N51RXRegistered aircraftBuilt 2025 · S/N 2436 N51SNDuke Vacation LLC · Wilmington, DEBuilt 2015 · S/N 1563 N51VTVirginia Tech Foundation Inc · Blacksburg, VABuilt 2000 · S/N 560-5072 N520CMOwl Hill Holdings LLC · Nashville, TNBuilt 2016 · S/N 4358 N520JACornerstone Air LLC · Wilmington, DEBuilt 2024 · S/N 2393 N520JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1446 N520VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5595 N521BBBell Bank · Fargo, NDBuilt 2022 · S/N 560-6329 N521CHSolomon Mark Trustee · Wilmington, DES/N 2023 N521JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1452 N521RTExcelsior Aviation Inc · Fresno, CABuilt 2020 · S/N 2057 N521SBBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5199 N521SHGlobal Crossing Airlines Inc · Miami, FLS/N 2840 N521TXReaper Air LLC · Nampa, IDBuilt 2016 · S/N 1670 N521UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3944 N521VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5651 N522CRFarrell Aircraft LLC · Lindon, UTBuilt 2017 · S/N 1694 N522GDL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5622 N522TLDodson International Parts Inc · Rantoul, KSS/N 98 N522VLBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 5776 N522WAGth Capital LLC · Phoenix, AZBuilt 2022 · S/N 2168 N523JBJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1506 N523JMJmac Air LLC · Columbus, OHBuilt 2009 · S/N 4150 N523UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3960 N523VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6014 N524ACPegasus Leasing LLC · Ada, MIBuilt 2013 · S/N 5433 N524BBBell Bank · Oklahoma City, OKBuilt 2018 · S/N 560-6259 N524DMMax Aircraft LLC · Moon Township, PABuilt 2011 · S/N 560-6090 N524DPDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 560-5526 N524JBJetbule Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1528 N524JDBristow LLC · Lake Charles, LABuilt 2012 · S/N 41301 N524RDKey Leasing LLC · Stroudsburg, PAS/N 1054 N524UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 3977 N524VAN524va Trust · Wilmington, DEBuilt 2007 · S/N 3204 N524VEBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5424 N524VLBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6161 N525BBBell Bank · Oklahoma City, OKBuilt 2020 · S/N 560-6285 N525VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6332 N526CFWolff 45 LLC · Ketchum, IDBuilt 2000 · S/N 45-124 N526DJMs Falcon LLC · East Spring Valley, NYBuilt 2003 · S/N 211 N526EMEmi Travel LLC · Tampa, FLBuilt 2016 · S/N 5537 N526GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5626 N526JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1546 N526RBPalm Beach County Sheriffs Office · West Palm Beach, FLBuilt 2021 · S/N 57427 N526SDWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5229 N526VLWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 6470 N527EECrown Aviation LLC · Holland, MIBuilt 2005 · S/N 560-5549 N527GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2020 · S/N 5627

Back to AD 2012-26-15 R1