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.

N851JSFe Xl 5111 LLC · Kinston, NCBuilt 2000 · S/N 560-5111 N851NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0609 N851UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1664 N851WUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5342 N852JSFe Xls 5566 LLC · Kinston, NCBuilt 2005 · S/N 560-5566 N852LHKriskraft Air LLC · Orange, CABuilt 2013 · S/N 560-6160 N852NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0614 N852UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1671 N852WCannon Corp · San Luis Obispo, CABuilt 2008 · S/N 1060 N853FCFoote Aviation LLC · Manhattan, KSBuilt 2016 · S/N 560-6211 N853JSFe Encore Plus I LLC · Kinston, NCBuilt 2003 · S/N 560-5352 N853LTN853lt Aviation LLC · Bixby, OKS/N 2032 N853NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0618 N853SATw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1586 N853UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1688 N854ANYonderbyrd LLC · Hickory, NCBuilt 2007 · S/N 560-5713 N854NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0620 N854UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1731 N855ACVision Jet LLC · Fort Wayne, INBuilt 2007 · S/N 560-5720 N855AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 41547 N855JRBoeing Co · Ridley Park, PABuilt 2026 · S/N 41827 N855JSFe 5064 LLC · Kinston, NCBuilt 2000 · S/N 560-5064 N855NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0621 N855SCStarlight Flights Aviation LLC · Wolfforth, TXBuilt 2008 · S/N 560-5763 N855UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 1737 N856AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 41553 N856GRKootenai Business Properties LLC · Post Falls, IDBuilt 2021 · S/N 2125 N856JRAgustawestland Philadelphia Corp · Philadelphia, PABuilt 2026 · S/N 41828 N856JSFe 5040 LLC · Kinston, NCBuilt 1999 · S/N 560-5040 N856LFInhs Leasing Company LLC · Aurora, ORBuilt 2009 · S/N 1134 N856NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0631 N856SMMasser Farming Inc · Sacramento, PABuilt 2020 · S/N 2056 N856STK&B Aviation LLC · Haymarket, VABuilt 2010 · S/N 1256 N857AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 41554 N857CBSpm3 LLC · Phoenix, AZBuilt 2019 · S/N 560-6278 N857GAPpg Industries Inc · West Mifflin, PABuilt 2019 · S/N 5596 N857JRLeonardo Helicopters US Corp · Philadelphia, PABuilt 2026 · S/N 41829 N857JSFe 5608 LLC · Kinston, NCBuilt 2006 · S/N 560-5608 N857NWDelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 0633 N8587HUp Management LLC · Rock Island, ILS/N 14501175 N858AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31850 N858JRLeonardo Helicopters US Corp · Philadelphia, PABuilt 2026 · S/N 41830 N858KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 5438 N858NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0718 N858PSPeri & Sons Farms Inc · Yerington, NVBuilt 2010 · S/N 1212 N859AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 41556 N859FTMf Equipment LLC · Uvalde, TXBuilt 2004 · S/N 560-5528 N859JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41831 N859NWDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 0722 N85CHAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2022 · S/N 2212

Back to AD 2012-26-15 R1