Skip to content

AD 2012-26-15 R1

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.

N38ADJrm Air LLC · Mooresville, NCBuilt 2019 · S/N 560-6282 N38NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2015 · S/N 5527 N38TVLs Mobile LLC · Weatherford, TXBuilt 1988 · S/N 37 N390CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32973 N390DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9066 N390HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1389 N390MDMaryland State Police Aviation Command · Middle River, MDBuilt 2014 · S/N 41377 N390UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67979 N391CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32975 N391DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9027 N391HAHawaiian Airlines Inc · Honolulu, HIBuilt 2013 · S/N 1399 N391UPCargo Aircraft Management Inc · Wilmington, OHS/N 28039 N392DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9028 N392HAWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 1404 N392UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 28041 N393DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9067 N393HAAlaska Airlines Inc · Seatac, WABuilt 2013 · S/N 1422 N393RARoeslein & Associates Inc · Chesterfield, MOBuilt 2022 · S/N 560-6328 N393UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29228 N393VFArrow 393 LLC · New York, NYBuilt 2008 · S/N 5205 N394BBBrown & Brown Inc · Daytona Beach, FLBuilt 2019 · S/N 560-6264 N394BHOld West Aviation LLC · Brighton, MIBuilt 2024 · S/N 57526 N394DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9125 N394UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25136 N395CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25447 N395DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9126 N395HAAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 1469 N395PH1698ng LLC · Marshalltown, IABuilt 2024 · S/N 2395 N395UPCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29229 N395WBCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1998 · S/N 009 N395WJRim 3 Group LLC · Waterford, MIBuilt 2003 · S/N 560-5330 N396CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25195 N396DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9128 N396DWWisch Aviation LLC · Houston, TXBuilt 2018 · S/N 560-6262 N396FGJet Star Inc · Jones Mills, PABuilt 2016 · S/N 1606 N396HAHawaiian Airlines Inc · Honolulu, HIBuilt 2014 · S/N 1488 N396JFSivu Transportation LLC · Anchorage, AKBuilt 2024 · S/N 2405 N396UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40364 N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982 N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035 N397BCBest Air Inc · Ferdinand, INBuilt 2002 · S/N 560-5291 N397DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9176 N397NGRs Management Consulting LLC · Glen Burnie, MDBuilt 2013 · S/N 1397 N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363 N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988 N398DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9360 N398MPBell Paul · Austin, TXBuilt 2022 · S/N 2154 N398PFP F D Supply Corp · Edwardsville, ILBuilt 2026 · S/N 560-6505 N398RSJpq1 LLC · Tonka Bay, MNS/N 560-5009 N399BTBell Textron Inc · Fort Worth, TXS/N 57013

Back to AD 2012-26-15 R1