Registered aircraft · 1,944

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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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:95-26-05-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.

N633AKAlpha Aviation LLC · Anchorage, AKBuilt 2025 · S/N 14904 N633CCGodspeed Leasing LLC · Fairbanks, AKBuilt 2007 · S/N 11207 N633JSJak2 Properties LLC · Ocala, FLBuilt 2024 · S/N 14747 N636DDAlba Aviation Services Inc · Scottsdale, AZBuilt 2001 · S/N 0974 N637AKR44 Leasing LLC · Dover, DEBuilt 2004 · S/N 10523 N637CSBoardman Air Service LLC · Henderson, NEBuilt 2009 · S/N 12687 N637HPSmt Ops Inc · Setauket, NYBuilt 2007 · S/N 11942 N637LNSouthern Utah University · Cedar City, UTBuilt 2007 · S/N 11637 N63ATRhynard Justin · Cedar Park, TXBuilt 2001 · S/N 1049 N63BKRegistration Pending · Aptos, CARegistration pendingBuilt 2008 · S/N 12602 N63HHSky Solutions LLC · Detroit, MIBuilt 2013 · S/N 13490 N641RTStanton Danny L · Franklin, NCBuilt 2006 · S/N 11384 N642RHValiair Lc Trustee · Casper, WYBuilt 2013 · S/N 2292 N644AFD & B Aviation Brokerage Services LLC · Wilmington, DEBuilt 2008 · S/N 12212 N644AKMd Ag Services LLC · Sterling City, TXBuilt 2004 · S/N 10364 N644BBAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2014 · S/N 13647 N644CHRowe James D · Nome, AKBuilt 2014 · S/N 13687 N644EZNorthern Air Spray LLC · Maple Grove, MNBuilt 2007 · S/N 11971 N644JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2014 · S/N 13732 N644KPRanger Lumber Corp · Springfield, MABuilt 2023 · S/N 14666 N644MCTj Aviation LLC · Blackfoot, IDBuilt 2013 · S/N 13516 N644MERas Aviation LLC · Mansfield, ILBuilt 2013 · S/N 13439 N644PCHeliflights LLC · Rahway, NJBuilt 2014 · S/N 13671 N644RABoston Helicopters · North Andover, MABuilt 2012 · S/N 2205 N644SPSouthern Sky Helicopters LLC · Easley, SCS/N 13661 N644VBNewton Christian David · Custer, SDBuilt 2016 · S/N 13978 N644WBWayne Mogg Inc · Rossmoor, CABuilt 2008 · S/N 12499 N6462YSalyards Aviation LLC · Whitehouse, TXBuilt 2016 · S/N 13993 N646MSEagle Soar LLC · Fort Worth, TXBuilt 2001 · S/N 1047 N649TWMarathon Leasing Inc · Elyria, OHBuilt 2006 · S/N 11514 N64BHJeff Staples Real Estate LLC · Kalispell, MTBuilt 2025 · S/N 14841 N654LHAeroluxe Aviation LLC · Nashville, TNBuilt 2004 · S/N 10362 N654SARotorcraftals LLC · Lafayette, INBuilt 2015 · S/N 13830 N6555CKiwi Air LLC · Clarkston, WAFirst renewal noticeBuilt 2005 · S/N 10965 N657JCCarpenter James D · Henderson, NVS/N 11890 N65VFSubmissive Air Inc · Deadwood, SDBuilt 2003 · S/N 10105 N65WDWade Ashley Bryan · Sulphur, LABuilt 2008 · S/N 12635 N661RRHelicopter Of Columbia LLC · Columbia, SCBuilt 1999 · S/N 0661 N661TVSky Helicopters Inc · Garland, TXBuilt 2009 · S/N 12509 N666NYFerrante Aviation Inc · Vandergrift, PABuilt 2007 · S/N 1679 N667SAHelicopter N667sa LLC · Lisbon, NDBuilt 2000 · S/N 0726 N668SANorth Country Heli-Flight Inc · Wilmington, DEBuilt 2004 · S/N 10371 N668TMAlpha Helicopters LLC · Lewes, DEBuilt 2000 · S/N 1032 N669JCMontana Sky Assets LLC · Helena, MTBuilt 2024 · S/N 14701 N669SCTranscare Ambulance Services Inc · Marion, INBuilt 2006 · S/N 11316 N669TMDirty Bird Helicopters LLC · Boerne, TXBuilt 2002 · S/N 1233 N66HVZibby Air LLC · Dover, DEBuilt 2013 · S/N 13499 N66UWCm3 LLC · North Las Vegas, NVBuilt 2000 · S/N 0802 N670EWEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2009 · S/N 12849 N671EMHambelton Robert · Klamath Falls, ORBuilt 2008 · S/N 12188

Back to AD 95-26-05 R1