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.

N344GStobbe Marlin · Ethridge, TNBuilt 2003 · S/N 10099 N344JGSmith Helicopters Inc · Cotulla, TXBuilt 2008 · S/N 12128 N344LCDuyk Charles W · Saint Petersburg, FLBuilt 2018 · S/N 2564 N344LRRotor Scooter LLC · Hauppauge, NYBuilt 2024 · S/N 14801 N344MGAir Service LLC · Wilmington, DEBuilt 2014 · S/N 13730 N344MTPalomino Creek LLC · Missoula, MTBuilt 2013 · S/N 13560 N344PCFlorida Cap Property Management Services LLC · Fort Lauderdale, FLBuilt 2023 · S/N 14680 N344RLRed R44 LLC · Wilmington, DEBuilt 2019 · S/N 2598 N344SAShier Aviation DBA · San Diego, CABuilt 2017 · S/N 30012 N344YUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 30056 N345EMLittle J Aviation LLC · Roswell, GABuilt 2004 · S/N 10416 N345WHEaves Glenn Ellsworth Jr · Rocky Ridge, MDBuilt 2016 · S/N 13961 N346GGJoey Os LLC · Darlington, PABuilt 2026 · S/N 14968 N34AUAirtime Ventures II LLC · Springfield, MOBuilt 2014 · S/N 13691 N34GHRoofing Guys LLC · Marion, ILS/N 10134 N34TBAmerican Helicopter Co LLC · Maiden, NCBuilt 2000 · S/N 0798 N34WHCarriere Trevor · Phoenix, AZBuilt 2012 · S/N 13227 N350DMR&J Helicopters LLC · Port Byron, ILBuilt 1997 · S/N 0366 N354GGRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 14969 N355AKAris Aviation Group LLC · Henderson, NVBuilt 2009 · S/N 12505 N355ASPollux Aviation Ltd · Wasilla, AKBuilt 2003 · S/N 10061 N356AKAris Aviation Group LLC · Henderson, NVBuilt 2008 · S/N 12597 N357ASAero Leasing Inc · Medford, ORBuilt 2004 · S/N 10477 N357EBSky Solutions LLC · Detroit, MIBuilt 2004 · S/N 10452 N357JPNovember Alpha LLC · Los Angeles, CABuilt 2005 · S/N 10943 N357TLRancho Bonito Livestock Inc · Menard, TXBuilt 2009 · S/N 12703 N358DGSky Equipment LLC · Salem, WIBuilt 2015 · S/N 13821 N359WHRobinson Helicopter Co · Torrance, CAS/N 15045 N360AHMagnuson Lloyd W · Opelousas, LAS/N 12594 N360PDPrecision Aerobatics Inc DBA · Santa Margarita, CABuilt 2010 · S/N 13051 N361JFFuller James K · Goliad, TXBuilt 2008 · S/N 12172 N363SKKamasano LLC · Highland, CABuilt 2011 · S/N 2164 N363WDFas Aviation LLC · Southlake, TXBuilt 2023 · S/N 14656 N365MSMaloney Leasing LLC · Tupelo, MSBuilt 2024 · S/N 14746 N367LALead Aviation Fl3 LLC · Osprey, FLBuilt 2016 · S/N 13966 N368MSSilvestri Mark J · Warwick, NYBuilt 2006 · S/N 11343 N368TMStriker LLC · Lewes, DEBuilt 2026 · S/N 14989 N369ATJogger Industries LLC · Sherwood, NDBuilt 2021 · S/N 14488 N369ELErickson Logging Inc · Gig Harbor, WAFirst renewal noticeS/N 1590 N36VBRhc1 LLC · Myrtle Beach, SCBuilt 2006 · S/N 11362 N370BBBuffalo Biodiesel Inc · Tonawanda, NYBuilt 2023 · S/N 14593 N370HMHoneybee Helicopters LLC · Kalispell, MTBuilt 2005 · S/N 10914 N371MPN371mp Inc · Middletown, DEBuilt 2019 · S/N 14298 N372WBCornelia Adair LLC · Amarillo, TXBuilt 2023 · S/N 14645 N373DC3d Capture LLC · Lumberton, TXBuilt 2024 · S/N 12626 N378WMHelo Holdings LLC · South Fork, COBuilt 2024 · S/N 14810 N379CCSmith Jason · Calliham, TXBuilt 2006 · S/N 1596 N37BKChanging Horizons LLC · Helena, MTBuilt 2004 · S/N 10542 N37EGVolterra LLC · Iowa City, IABuilt 2017 · S/N 14125 N37KMRobinson Helicopter Co · Torrance, CAS/N 15061

Back to AD 95-26-05 R1