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.

N527JGGibbs International Inc · Spartanburg, SCBuilt 2005 · S/N 5067 N527JLJetblue Airways Corp · Long Island, NYBuilt 2001 · S/N 1557 N527NKGryphon Trading Company LLC · Fort Lauderdale, FLBuilt 2007 · S/N 2978 N527SRedleaf Management Company LLC · Miami, FLS/N 8 N527VAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 3417 N527VKThor Aero LLC · Fargo, NDBuilt 2016 · S/N 1619 N527VLWilmington Trust Na Trustee · Wilmington, DEBuilt 2015 · S/N 6705 N528ACLegend Air LLC · Waukesha, WIS/N 560-5695 N528APArrow Plane Lc · Provo, UTBuilt 2007 · S/N 5168 N529AMLendingclub Bank Na · Boston, MABuilt 2019 · S/N 57375 N529CGCargo Aircraft Management Inc · Wilmington, OHS/N 529 N529GAL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 2021 · S/N 5629 N529GBBmh Air LLC · Fredericksburg, TXBuilt 2007 · S/N 14500994 N529JBJetblue Airways Corporation · Long Island City, NYBuilt 2001 · S/N 1610 N529LECollier County Sheriffs Office · Naples, FLBuilt 2021 · S/N 57435 N529LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 560-5557 N529NGOredigger Air Pc12 LLC · Highlands Ranch, COBuilt 2015 · S/N 1529 N529NMTnm Enterprises LLC · Newark, DEBuilt 2017 · S/N 560-6182 N52GXD&D Aviation Inc · Olathe, KSBuilt 2020 · S/N 2052 N52HXHelicopter Express LLC · Chamblee, GABuilt 2010 · S/N 57026 N52MWManagement West LLC · Aurora, ORBuilt 2011 · S/N 560-6085 N52NGStone Aviation Holdings LLC · Wilmington, DEFirst renewal noticeBuilt 2013 · S/N 1452 N530FLBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1153 N530GL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5630 N530PMEbts LLC · New York, NYBuilt 2004 · S/N 5031 N530XTBank Of Utah Trustee · Salt Lake City, UTS/N 4931 N531AFRigi Inc · Portsmouth, NHBuilt 2015 · S/N 1531 N531GAL3harris Technologies Flight Capital LLC Trustee · Greenville, TXBuilt 2021 · S/N 5631 N531JLJetblue Airways Corp · Long Island City, NYBuilt 2001 · S/N 1650 N531JRBoeing Co · Ridley Park, PABuilt 2024 · S/N 41814 N5326SFly Wright LLC · Maple Lake, MNBuilt 2009 · S/N 1131 N532MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 560-6118 N533CCMt Aviation LLC · Cincinnati, OHBuilt 2010 · S/N 560-6063 N533GVWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 5330 N534CCMagg One Holdings LLC · Fulton, MDBuilt 2010 · S/N 560-6070 N534GMOklahoma LLC · Sandy, UTBuilt 2009 · S/N 1112 N534JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1705 N534LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32572 N534NTIvy Brothers Aviation LLC · Gladewater, TXS/N 439 N534UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3989 N535JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1739 N535MAWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 560-6256 N535MJVanderbilt University Medical Center · Nashville, TNBuilt 2009 · S/N 1157 N535PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 1057 N535PTOas 3 LLC · Orlando, FLBuilt 2010 · S/N 1200 N535TBEuroaviation Inc Trustee · KematenBuilt 2014 · S/N 57213 N535UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 3993 N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360 N536HCPc12a LLC · Marshalltown, IABuilt 2017 · S/N 1702 N536JA560-5166 LLC · Greenfield, INBuilt 2001 · S/N 560-5166

Back to AD 2012-26-15 R1