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.

N322WBFranco Property LLC · Houston, TXBuilt 2014 · S/N 13765 N3231JNovember Alpha LLC · Dover, DEBuilt 2007 · S/N 11633 N3233ESilver Star Helicopters LLC · El Campo, TXBuilt 2007 · S/N 11661 N3238RSublime Aerials LLC · Madison, WIBuilt 2007 · S/N 11646 N323MWBoomerang Air LLC · Cedar Park, TXBuilt 2006 · S/N 11501 N323TTRtw Adventures LLC · Post Falls, IDBuilt 2023 · S/N 14626 N323WTServices By Pps Inc · St George, UTBuilt 2023 · S/N 14640 N3246HBarnhill Gregory L · Leawood, KSBuilt 2007 · S/N 11698 N324CADrakes Landing Inc · Archibald, LABuilt 2023 · S/N 14605 N324CSBrush Country Helicopters LLC · Laredo, TXBuilt 2013 · S/N 2321 N3255HAlba Leasing Services LLC · Scottsdale, AZBuilt 2007 · S/N 11686 N325SMPurple Raven Partners LLC · Lexington, KYBuilt 2006 · S/N 11469 N3264UTri-B Air LLC · Plano, ILS/N 1715 N326CLState Of Alaska · Anchorage, AKBuilt 2022 · S/N 14573 N328SSUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2002 · S/N 1214 N328VRotors Away LLC · Bayside, NYBuilt 2015 · S/N 13799 N3297QUtah Helicopter LLC · Spanish Fork, UTS/N 10178 N329ABDm Aviation Services LLC · Kennebunk, MEBuilt 2004 · S/N 10578 N329JKEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2005 · S/N 10674 N32GSZeigler Corey M · Harrisville, NYBuilt 1993 · S/N 0016 N32LLKeys Aviation LLC · Key West, FLBuilt 2021 · S/N 14441 N32RPHelijet2025 Inc Trustee · Wilmington, DEBuilt 2015 · S/N 13834 N331AHArmstrong Helicopters LLC · Laredo, TXBuilt 2003 · S/N 10042 N331ELNantucket Helicopters LLC · Nantucket, MABuilt 2023 · S/N 14667 N331ESJackson Paul D · Chesapeake, VABuilt 2001 · S/N 1067 N332BDN332bd Corp Trustee · Wilmington, DES/N 11332 N332WBLyle Ronny D DBA · Como, TXBuilt 2018 · S/N 14237 N333LESky Photoshop LLC · Winter Garden, FLBuilt 2021 · S/N 2666 N333RZJj Magic LLC · Wilmington, DEBuilt 2003 · S/N 10167 N333UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2013 · S/N 13626 N334WCFarmland Developers LLC · Jonesboro, ARBuilt 2016 · S/N 30009 N335APAndy Petree Inc · Denver, NCBuilt 2012 · S/N 13376 N335PDRogue Aviation LLC · Newport Beach, CABuilt 2005 · S/N 10611 N335TBpu Enterprises LLC · Schuylkill Haven, PABuilt 2016 · S/N 2452 N336EDAdvanced Therapy Products Inc · Richmond, VABuilt 2013 · S/N 13461 N336SGAndrade South Florida Services Inc · Plantation, FLS/N 1336 N337MGTew-Mac LLC · Tewksbury, MABuilt 2025 · S/N 2810 N337MHEagle Eye LLC · Houma, LABuilt 2022 · S/N 14535 N338SGMaine Rock And Recycling LLC · Rollinsford, NHS/N 1338 N339LLThro Flight Inc · Boca Raton, FLBuilt 2025 · S/N 14883 N33CXK & S Irrigation Inc DBA · Higbee, MOS/N 10569 N3402Nitzsche Ren · Winter Garden, FLBuilt 2023 · S/N 14675 N3413XAll Her Fault LLC · Fairbanks, AKBuilt 2005 · S/N 10831 N341CCContinental Helicopters Inc · Sheffield, TXBuilt 2007 · S/N 11707 N342LSAutorotation Aviation LLC · Ardmore, OKBuilt 2013 · S/N 13474 N344AKChavi LLC · Fredericksburg, TXBuilt 2008 · S/N 12166 N344BBMansfield Heliflight · Milton, VTBuilt 2001 · S/N 1159 N344BHBlack Hills Aviation Leasing LLC · Rapid City, SDBuilt 2024 · S/N 14763 N344CFKey West Helicopters LLC · Key West, FLBuilt 2004 · S/N 10440 N344ESLake Superior Helicopters LLC · Duluth, MNBuilt 2015 · S/N 2402

Back to AD 95-26-05 R1