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.

N901WHAlpha Helicopters LLC · Lewes, DEBuilt 2008 · S/N 1921 N902HTTorrance, CAAssigned, pending cancellationBuilt 2026 · S/N 14996 N904YKSky Solutions LLC · Westland, MIS/N 0742 N907HGDenali North Side Adventures LLC · Wasilla, AKBuilt 2005 · S/N 10790 N907JSStevenson William E · Sutton, AKBuilt 2015 · S/N 2406 N907LLAerial Ag Services LLC · Hillsboro, TXBuilt 2006 · S/N 11184 N907MHMvs Holdings LLC · Wilmington, DEBuilt 2025 · S/N 14826 N907RBSunrise Aero LLC · Nikiski, AKBuilt 2016 · S/N 13954 N907VSRegistered aircraftBuilt 2013 · S/N 13455 N907YKAlaska Channel Inc · Anchorage, AKBuilt 2017 · S/N 14057 N910PSSpitzer Helicopter LLC · Woodland Hills, CABuilt 2014 · S/N 2329 N911TMExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2003 · S/N 10194 N912AGP3 Aviation Services LLC · Wilmington, DEBuilt 2013 · S/N 13601 N912TPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2012 · S/N 13270 N913WLThunderbird Aviation LLC · Littleton, COBuilt 2006 · S/N 11320 N914GHCantrell Grady DBA · Los Banos, CABuilt 2004 · S/N 10232 N914RPPeak Helicopters Inc · Haines, ORBuilt 2006 · S/N 11448 N914SKElkhorn Aviation Inc DBA · Baker City, ORBuilt 2006 · S/N 11250 N915BKKnight Flight Aviation LLC · Hampstead, NCBuilt 2026 · S/N 14948 N915BWPigneri Paul A · Long Beach, CAExpired dealerBuilt 2006 · S/N 11428 N915HGR44 Leasing LLC · Anchorage, AKBuilt 2017 · S/N 14053 N916APSg Helicopter Training LLC · White Plains, NYBuilt 2006 · S/N 11216 N917LCCoffey Fx Delivery Inc · Lincoln, NEBuilt 2023 · S/N 14663 N918BSRotor Ops 269 LLC · Wilmington, DEBuilt 2015 · S/N 13843 N919DJPope James D · Lewiston, IDBuilt 2005 · S/N 10644 N919HCPrime Aviation LLC · Bandera, TXBuilt 2007 · S/N 11975 N919HGRegistered aircraftBuilt 2019 · S/N 30062 N919KTAir One Helicopters LLC · Lincoln Park, MIBuilt 2021 · S/N 14457 N919LCDustin Graham Enterprises Helicopter Division LLC · Lakeside, AZBuilt 2015 · S/N 13885 N919SKPatriot Boat And Rv Stroage LLC · Lindale, TXBuilt 2011 · S/N 13135 N91AV2010 Leasing Group LLC · Torrance, CABuilt 2006 · S/N 11392 N91HWNortheast Cubs LLC · Wilmington, DEBuilt 2018 · S/N 2537 N921JMFlight Equity LLC · Fayetteville, ARBuilt 2004 · S/N 10565 N922ABDix Justin T · South Boston, VABuilt 2001 · S/N 1083 N922PPDirectional Holdings LLC · Missoula, MTBuilt 2015 · S/N 13776 N924DMSmoketown Helicopters LLC · Smoketown, PABuilt 2002 · S/N 1253 N925WLCrosswind Leasing LLC · Prescott, AZBuilt 2004 · S/N 10462 N926HERobinson Helicopter Co · Torrance, CAS/N 15034 N928DVValentine Donovan DBA · Hendersonville, TNBuilt 2023 · S/N 14676 N928KJComplete Demolition Services LLC · Louisville, KYBuilt 2024 · S/N 14787 N928KPMy Neighbors Helicopters LLC · Duluth, MNBuilt 2004 · S/N 10118 N928VRMillhorn Herb W · Worley, IDBuilt 2011 · S/N 13161 N928WTMoxie Leasing LLC · Clarkdale, AZBuilt 2011 · S/N 13163 N929DBRiley Livestock Inc · Mayfield, KYS/N 13603 N929WAWings Air Helicopters LLC · West Harrison, NYBuilt 2018 · S/N 14233 N92KFHodel Christopher J · Anchorage, AKBuilt 2015 · S/N 2400 N92MEAirplane Ventures LLC · Carrollton, TXBuilt 2024 · S/N 14715 N930DKCity Of Lakewood · Lakewood, CABuilt 2016 · S/N 13963 N931QACullman Rotorcraft Inc · Vinemont, ALBuilt 2001 · S/N 0986 N931TGMdr Helicopter LLC · Atkinson, NEBuilt 2006 · S/N 11559

Back to AD 95-26-05 R1