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.

N911FDMiami-Dade Fire Rescue Department · Miami, FLBuilt 2020 · S/N 41568 N911FKMonroe County Florida · Key West, FLBuilt 2025 · S/N 41606 N911FRMiami Dade Fire Rescue Department · Miami, FLBuilt 2020 · S/N 41569 N911GWWilliams Aviation LLC · San Mateo, CABuilt 2023 · S/N 2287 N911JLJefferson Parish Sheriffs Office · Harvey, LABuilt 2012 · S/N 57096 N911KXLendingclub Bank Na · Boston, MABuilt 2011 · S/N 57002 N911LKMonroe County Florida · Key West, FLBuilt 2025 · S/N 41605 N911MNAvera Mckennan · Sioux Falls, SDBuilt 2018 · S/N 1790 N911NMSan Juan Regional Medical Center · Farmington, NMBuilt 2010 · S/N 57031 N911RAMiami Dade Fire Dept · Miami, FLBuilt 2020 · S/N 41570 N911RRMonroe County Florida · Key West, FLBuilt 2025 · S/N 41601 N911VHCook County Sheriff'S Office · Chicago, ILBuilt 2024 · S/N 57524 N911ZPCity Of Chicago Department Of Police · Chicago, ILBuilt 2024 · S/N 57505 N912NMSan Juan Regional Medical Center Inc · Farmington, NMBuilt 2021 · S/N 2085 N912UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67981 N912UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6264 N912WCPdwc H8r LLC · Dover, DEBuilt 2009 · S/N 1118 N913CLDp Leasing LLC · Gilford, NHBuilt 2007 · S/N 560-5718 N913JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5909 N913JRJtv Transportation LLC · Painesville, OHBuilt 2016 · S/N 1603 N913MKTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2007 · S/N 4075 N913SBValley Iron Inc · Fresno, CABuilt 2020 · S/N 2024 N913TFTosh Farms · Henry, TNBuilt 2022 · S/N 560-6336 N913UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67982 N913USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6255 N914SSMeregrass Inc · Dublin, TXBuilt 2001 · S/N 188 N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14 N914UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67983 N914UYAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6337 N915JLDorsch Peter J Trustee · Green Bay, WIBuilt 2014 · S/N 1468 N915LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 182 N915NXP4 Management Partners LLC · Wilmington, DEBuilt 2019 · S/N 1915 N915TBBmc Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4039 N915TMTomel Holdings LLC · Idalou, TXBuilt 2007 · S/N 560-5698 N915TPGlobe Resources Group LLC · Wichita, KSBuilt 1992 · S/N 122 N915UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67984 N915USAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6387 N916AFTvpx Aircraft Solutions Inc Trustee · Portsmouth, NHBuilt 2020 · S/N 2016 N916BDDillards Inc · Tunica, MSBuilt 2015 · S/N 520 N916CSAvlease Company LLC · Ann Arbor, MIBuilt 2010 · S/N 560-6062 N916JRock Springs Management Inc · Great Bend, KSBuilt 2023 · S/N 560-6353 N916MBMb-Air LLC · Oklahoma City, OKBuilt 2025 · S/N 2461 N916UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67985 N916USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6420 N916VDCdr Capital LLC · Miami, FLBuilt 2015 · S/N 5509 N917BCFlyaway Inc · Fort Worth, TXS/N 193 N917BDDillard'S Inc · Tunica, MSBuilt 2015 · S/N 517 N917BERegistration Pending · Cottonwood Heights, UTRegistration pendingBuilt 2001 · S/N 143 N917CJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5399 N917GAPhoenix Esprit II LLC · Austin, TXBuilt 2011 · S/N 5317

Back to AD 2012-26-15 R1