Registered aircraft · 1,939

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.

N150BRegistered aircraftRegistration pendingBuilt 2002 · S/N 1199 N150XTRice John D · Maddock, NDBuilt 2007 · S/N 1746 N151CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2007 · S/N 1705 N151HMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2005 · S/N 10617 N151TLAlpine Air Alaska LLC · Girdwood, AKBuilt 2004 · S/N 10599 N152SVeracity Aviation LLC · Seguin, TXBuilt 2018 · S/N 14250 N153LACarolina Mobile Storage LLC · Prestonsburg, KYBuilt 2013 · S/N 13422 N153WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1995 · S/N 0152 N154ABills Helicopter Service LLC · Woodlawn, VAS/N 0558 N155CPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10933 N155HBering Air Inc · Nome, AKBuilt 2011 · S/N 13134 N155MGVeracity Aviation LLC · Seguin, TXBuilt 2009 · S/N 12713 N157HPN344vg LLC · Princeton, NJBuilt 2006 · S/N 11057 N158CRA2heli LLC · Ann Arbor, MIBuilt 2017 · S/N 2466 N159GDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 12037 N159MHPw Air LLC · Rockingham, VABuilt 2001 · S/N 1135 N159RPHeadings Norman D · Walnut, ILBuilt 1997 · S/N 0342 N15HPCoastal Helicopters Inc · Ocracoke, NCBuilt 2016 · S/N 14018 N15PKJones Helicopters LLC · Villa Rica, GABuilt 2012 · S/N 13256 N161BWWelch William Ben · Danville, ILBuilt 2005 · S/N 10601 N161CMR&J Helicopters LLC · Port Byron, ILBuilt 2016 · S/N 2444 N161SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14731 N161WPJax Transport LLC · Amarillo, TXBuilt 2005 · S/N 1490 N162SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14729 N163RKGardner Michael John · Ashland, ILBuilt 2006 · S/N 11120 N163SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14730 N164RKAerinova Inc · Mattoon, ILBuilt 2006 · S/N 11467 N164SAOlson Helicopters LLC · Corpus Christi, TXBuilt 2006 · S/N 1559 N164SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14713 N165PTNovember Alpha LLC · Dover, DEBuilt 2005 · S/N 10604 N165SUBeckett David · Wasilla, AKBuilt 2020 · S/N 30074 N166SUSouthern Utah University · Cedar City, UTBuilt 2020 · S/N 14379 N167SHSaratoga Aviation LLC · Wilmington, DEBuilt 2007 · S/N 11640 N167SUSouthern Utah University · Cedar City, UTBuilt 2020 · S/N 30064 N168AVAce Helicopters LLC · Colfax, WIBuilt 2008 · S/N 1968 N168BANomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2002 · S/N 1176 N1695XIdaho Dunes Holdings LLC · St Anthony, IDBuilt 2023 · S/N 14602 N169CSChavi LLC · Fredericksburg, TXBuilt 2015 · S/N 2407 N169SUSouthern Utah University · Cedar City, UTBuilt 2011 · S/N 13146 N16FTDwm LLC · Fairmont, NDS/N 11853 N171SHDriftless Helicopters LLC · Galena, ILBuilt 2007 · S/N 11678 N171WCRegistration Pending · Flora, ILRegistration pendingBuilt 1997 · S/N 0331 N171WTB&B Aero LLC · Arlington, MABuilt 2009 · S/N 2064 N174BARafter Gs Aviation LLC · San Antonio, TXBuilt 2013 · S/N 13486 N175KMNovember Alpha LLC · Dover, DEBuilt 2008 · S/N 12106 N175MK175mk LLC · Webberville, MIBuilt 2004 · S/N 10247 N175RVWings Air Helicopters LLC · West Harrison, NYBuilt 2006 · S/N 11175 N177CS833 Lakeside LLC · Downers Grove, ILS/N 1269 N177PBEast Coast Helicopter Operations LLC · Hedgesville, WVBuilt 2006 · S/N 11324 N17EMSegerstrom Ricky G Trustee · Grandview, TXBuilt 2006 · S/N 1580

Back to AD 95-26-05 R1