Skip to content

AD 2012-26-15 R1

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.

N747UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1301 N748AVNavigator Aviation II Msn 6862 Trust · Wilmington, DEBuilt 2015 · S/N 6862 N748UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1311 N748WRt Air II LLC · Little Rock, ARBuilt 2004 · S/N 560-5531 N749AFMcchord Austin · Portsmouth, NHBuilt 2017 · S/N 1749 N749AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22226 N749BCAlta 777 LLC · Salt Lake City, UTS/N 33372 N749USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1313 N749XLMitchco Air LLC · Louisville, KYBuilt 2005 · S/N 560-5577 N74VZRegistered aircraftBuilt 2020 · S/N 5619 N750ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30259 N750AVNavigator Aviation II Msn 7120 Trust · Wilmington, DEBuilt 2016 · S/N 7120 N750AXBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 22227 N750BABklavi LLC · New Richmond, WIBuilt 1998 · S/N 560-5002 N750JEJae Aviation LLC · Englewood, COBuilt 1997 · S/N 53 N750LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 5096 N750LLJet Allen LLC · Tulsa, OKBuilt 2013 · S/N 474 N750STValiair Lc Trustee · Casper, WYBuilt 2012 · S/N 2133 N750UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1315 N751ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30798 N751ECN751ec LLC · Helena, MTBuilt 2019 · S/N 578 N751JCCbr Aviation LLC · Delaware, OHBuilt 2001 · S/N 134 N751LGWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 5244 N751UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1317 N752ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30260 N752AXAeroacq Partners LLC · Laud By Sea, FLS/N 23434 N752RBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 485 N752SPPrincipal Aviation Partners LLC · Camden, DEBuilt 2005 · S/N 14500903 N752USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1319 N753ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30261 N753SLVentus Mf LLC · Boise, IDS/N 57305 N753USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1326 N754ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30262 N754JLNewport Blue LLC · Corona Del Mar, CABuilt 1989 · S/N 54 N754UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1328 N755AFHoward Phipps J Jr · Portsmouth, NHBuilt 2017 · S/N 1755 N755ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30263 N755AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTBuilt 2016 · S/N 7437 N755GXAis Wings LLC · Grand Rapids, MIBuilt 2022 · S/N 2198 N755PMPjm Associates LLC · Jordan, MNBuilt 2010 · S/N 1239 N755SLVentus Mf LLC · Boise, IDBuilt 2016 · S/N 57307 N755USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1331 N756AMAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30264 N756USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1340 N757ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32636 N757BTAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2010 · S/N 1247 N757TSAero-Tech Services Inc · Lancaster, PABuilt 2016 · S/N 1644 N757UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1342 N758AJetright IV LLC · Nashville, TNBuilt 2017 · S/N 553 N758ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 32637

Back to AD 2012-26-15 R1