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.

N4043BCrown Point Helicopter LLC · Morton Grove, ILBuilt 2021 · S/N 14431 N4043PPolar Star Corp · Kalispell, MTBuilt 2018 · S/N 14214 N40444Robinson Helicopter Co · Torrance, CABuilt 2024 · S/N 14735 N40479November Alpha LLC · Dover, DEBuilt 2026 · S/N 14979 N40489Classic Drywall LLC · Richmond, KYBuilt 2026 · S/N 30113 N404GAEly Ag Services LLC · Sallisaw, OKBuilt 2005 · S/N 10953 N404GGNext Level Aviation LLC · Pflugerville, TXBuilt 2015 · S/N 13832 N404MTJeff Rochelle LLC · Daytona Beach, FLS/N 11158 N404SDToms Aviation Inc · Addison, ILBuilt 2006 · S/N 11217 N40521Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 14582 N4052MKroeplin Air LLC · Highmore, SDBuilt 2023 · S/N 14654 N4053TSky High Helicopters LLC · Camarillo, CABuilt 2018 · S/N 30045 N4054GWorks Mark S · Cincinnati, OHBuilt 2023 · S/N 30095 N4054YMaloney Leasing LLC · Tupelo, MSS/N 13525 N4055KHarris William R Jr · Salisbury, CTBuilt 2020 · S/N 2611 N4055NKansara Sanjay · Coopersburg, PABuilt 2020 · S/N 2619 N4055QAeroglyphs Raven One LLC · Portland, ORS/N 2621 N4056VHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2023 · S/N 30093 N4057SValley View LLC · Dover, DEBuilt 2023 · S/N 14689 N405PHFlap-Air Helicopter Service Inc · Canadian, TXBuilt 2024 · S/N 14738 N405RBOwens Aviation LLC · Elm City, NCBuilt 2011 · S/N 13154 N405RRBjp Aviation LLC · Seattle, WABuilt 2005 · S/N 10700 N406DLNon-Stop Enterprises LLC · Canoga Park, CABuilt 2024 · S/N 14665 N406HLHelicopter Logging LLC · Lagrange, OHBuilt 2012 · S/N 2197 N406RJSkywest Aviation Inc Trustee · Albuquerque, NMBuilt 2008 · S/N 12532 N408CLExecutive Helicopter Tours Inc · Saint Petersburg, FLBuilt 2007 · S/N 11722 N408RGGould Rod · Milford, IABuilt 2018 · S/N 14183 N4097LSinkule Jim · West, TXBuilt 2007 · S/N 12072 N409DCSpitzer Helicopter LLC · Wilmington, DES/N 13710 N409MBNiner LLC · Wilmington, DEBuilt 2023 · S/N 14621 N409SHSky Solutions LLC · Westland, MIBuilt 2008 · S/N 12409 N410AFJm Aviation II LLC · Little Falls, MNBuilt 2010 · S/N 13097 N411TCBusy Bee Helicopter LLC · Paulding, OHBuilt 1994 · S/N 0034 N411TVSky Helicopters Inc · Garland, TXBuilt 2014 · S/N 13613 N411VFMay Ricky · Salem, VABuilt 2003 · S/N 1307 N411VSRegistration Pending · Anchorage, AKRegistration pendingBuilt 2004 · S/N 10251 N4124DAshcraft Matthew · Abbott, TXFirst renewal noticeS/N 12095 N4125TSummerskyz Inc · Saint Joseph, ILBuilt 2008 · S/N 12100 N4126ANovember Alpha LLC · Dover, DEBuilt 2008 · S/N 12096 N41279Paratus Air DBA · Auburn, INBuilt 2008 · S/N 1909 N4131GAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2007 · S/N 12082 N4132ZVertical Lift Inc · Friendship, WIBuilt 2008 · S/N 12113 N41352Custom Ppg Inc · Browns Summit, NCBuilt 2008 · S/N 12352 N4136XSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 2008 · S/N 12114 N4137MKropf Flying Service LLC · Harrison, ARBuilt 2008 · S/N 12115 N413DBEstelle Karsen · Mc Neal, AZBuilt 2003 · S/N 1299 N41402Isofly LLC · Canyon Country, CABuilt 2008 · S/N 1934 N41411Aerinova Inc · Mattoon, ILBuilt 2008 · S/N 12429 N41431Nally & Hamilton Enterprises Inc · Bardstown, KYBuilt 2008 · S/N 12441 N4149DLangley Richard · Sheyenne, NDBuilt 2008 · S/N 12184

Back to AD 95-26-05 R1