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.

N105UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 1999 · S/N 0868 N10666Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5404 N106DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 10088 N106ECAurogold Aviation Inc Trustee · Wilmington, DEBuilt 2009 · S/N 14501106 N106GKVrs Holdings LLC · Medina, OHBuilt 2013 · S/N 2134 N106NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 5932 N106TWTw Leasing LLC · Oxford, CTS/N 1109 N107DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 9582 N107GLLeep Enterprises LLC · Mishawaka, INBuilt 2002 · S/N 199 N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N107NNUmb Bank N A Trustee · Salt Lake City, UTBuilt 2014 · S/N 5938 N107USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1052 N107VSSterling2k LLC · Woodbury, NYBuilt 2004 · S/N 5043 N1088RHampton Railway LLC · Eugene, ORBuilt 2013 · S/N 560-6156 N108DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10003 N108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNBuilt 1991 · S/N 108 N108KNStuckey Connections LLC · Magnolia, TXBuilt 2007 · S/N 336 N108NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5946 N108PHYoung Family Aviation LLC · Sugar Grove, ILBuilt 1990 · S/N 87 N108UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1061 N109DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 9588 N109DRBristow LLC · Lake Charles, LAS/N 31311 N109LWWeisbrod & Weisbrod Pc · Dallas, TXBuilt 2000 · S/N 071 N109NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 5955 N109UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1065 N10DFGulf States Toyota Inc · Houston, TXS/N 1241 N10HCKba LLC · Dover, DEBuilt 2008 · S/N 14501080 N10JMov Aviation LLC · Wilmington, DEBuilt 2007 · S/N 337 N10JPPvm Management LLC · Wilmington, DEBuilt 2008 · S/N 4121 N10NLO Neal Industries Inc · Birmingham, ALBuilt 2000 · S/N 128 N10PHBlue Sky Harbour LLC · Hummelstown, PABuilt 2013 · S/N 560-6142 N10QS25p150c LLC · Oklahoma City, OKBuilt 2026 · S/N 560-6507 N10WAReinbeck Motors Co Inc · Reinbeck, IABuilt 2022 · S/N 2187 N10XBmd Leasing LLC · Portland, ORBuilt 2001 · S/N 190 N10XGBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 5186 N110ABTbf Group Aviation LLC · Great Neck, NYBuilt 2000 · S/N 125 N110ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5975 N110DTTillman Self Storage Inc · Wilmington, DEBuilt 2001 · S/N 560-5145 N110DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10015 N110GNWell Adjusted LLC · Naples, FLBuilt 2013 · S/N 1404 N110GWGew Aircraft Leasing LLC · Naples, FLBuilt 2013 · S/N 2457 N110UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1112 N110WALacey Transport LLC · Oskaloosa, IABuilt 2009 · S/N 4179 N111Bar Holdings Management LLC · Los Angeles, CABuilt 2015 · S/N 5506 N111CXMojave Jet LLC · Nolensville, TNS/N 0711 N111DCDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10018 N111FEFederal Express Corp · Memphis, TNBuilt 2020 · S/N 64060 N111FJJfm Air LLC · Wilton Manors, FLBuilt 1993 · S/N 128 N111TDWaskey Realty LLC · Baton Rouge, LABuilt 2014 · S/N 57250 N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114

Back to AD 2012-26-15 R1