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.

N917JFAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1999 · S/N 179 N917JGPacific Crest Air LLC · Modesto, CABuilt 2017 · S/N 1723 N917PDNew York City Police Department · Brooklyn, NYBuilt 2013 · S/N 57148 N917UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68363 N917UYAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6427 N917VZKern Rene · Cleveland, OHBuilt 2017 · S/N 4364 N918AFRigi Inc · Portsmouth, NHBuilt 2019 · S/N 1918 N918CCAstor Street Asset Management Inc · Chicago, ILBuilt 2006 · S/N 4052 N918EGOmni Aircraft Maintenance LLC · Tulsa, OKBuilt 2001 · S/N 154 N918LBBva Operations LLC · Miami Beach, FLBuilt 2010 · S/N 4199 N918LLSienna Services Inc · Wilmington, DEBuilt 2009 · S/N 4177 N918LSSamson Energy Company LLC · Tulsa, OKBuilt 2016 · S/N 547 N918MVGuardian Aviation Services LLC · Short Hills, NJBuilt 1996 · S/N 156 N918PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57188 N918PTTennthom Aviation Corp · La Vergne, TNBuilt 2016 · S/N 542 N918RZBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 560-6130 N918TRExecutive Pl Solutions LLC · Salt Lake City, UTBuilt 2021 · S/N 57426 N918UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68364 N918USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6443 N918WBChoice Administrators Insurance Services Inc · Orange, CABuilt 2005 · S/N 5072 N919CHLeipold Aircraft LLC · Racine, WIS/N 205 N919JSTo US Aviation LLC · Burlingame, CABuilt 2024 · S/N 2346 N919PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57220 N919PKTw Leasing LLC · Oxford, CTBuilt 2008 · S/N 1095 N919UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68365 N919USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6479 N91GVAir Lake Lines IV Inc · Saint Paul, MNBuilt 2006 · S/N 4053 N91KCEagle Mountain International Church Inc · Newark, TXBuilt 2014 · S/N 1484 N91LAAviation Leasing Co LLC · New York, NYBuilt 2003 · S/N 5027 N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10 N91RLRoux Investment Management Co LLC · Sarasota, FLBuilt 2023 · S/N 2255 N91SKWos Holdings II LLC · Belgrade, MTBuilt 2014 · S/N 1492 N91SURegistered aircraftBuilt 2015 · S/N 528 N920MDN920md LLC · Oklahoma City, OKBuilt 2000 · S/N 120 N920PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57233 N920UPBoeing Co · Renton, WABuilt 2026 · S/N 68366 N920USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6490 N9211GValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 2373 N921BRN921br LLC · Sulpher, OKBuilt 2002 · S/N 560-5288 N921CGOffshore Energy Service Inc · Broussard, LABuilt 2014 · S/N 560-6174 N921NGLm Aviation LLC · Goshen, INBuilt 2019 · S/N 1921 N921TBBluemaxx Air LLC · Friendswood, TXS/N 85 N921UPBoeing Co · Renton, WABuilt 2026 · S/N 68367 N921USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6523 N922PBGreat Basin Advisors LLC · Menlo Park, CABuilt 2015 · S/N 1580 N922STSan Tomo Inc · Stockton, CABuilt 2014 · S/N 57206 N922UPBoeing Co · Renton, WABuilt 2026 · S/N 68368 N922USAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6537 N922WV316sa LLC · Paragould, ARBuilt 2009 · S/N 1166 N923AFKamm Investments LLC · Portsmouth, NHBuilt 2020 · S/N 2023

Back to AD 2012-26-15 R1