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.

N383TNNipper Troy R · Texarkana, TXS/N 13411 N383TYCrawford Randall Jay · Jal, NMS/N 13303 N384HRHolt John T · Big Lake, TXBuilt 2020 · S/N 14384 N385CMCoastal Elite Air LLC · Helena, MTBuilt 2024 · S/N 14782 N386RHBlue Hill Helicopters LLC · Norwood, MABuilt 2012 · S/N 13386 N387TBP5 Aviation LLC · Cumming, GABuilt 2008 · S/N 12574 N387VBEnt Aviation LLC · Smithfield, VABuilt 2021 · S/N 14478 N388DWDunlap Farms Equipment LLC · Williams, CABuilt 2004 · S/N 10400 N389AKAlpha Aviation LLC · Anchorage, AKBuilt 2022 · S/N 14543 N38AXAxis Helicopters LLC · Port Arthur, TXBuilt 2008 · S/N 12248 N38RJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 11770 N38VBCactus Land And Cattle LLC · Ephrata, WAS/N 11626 N390AKJerry Trimble Helicopters Inc · Mcminnville, ORBuilt 2009 · S/N 12887 N391LVSmart James T · Spurger, TXS/N 0555 N393DMAlba Leasing Services LLC · Scottsdale, AZBuilt 2005 · S/N 10834 N393NMAce High Helos LLC · El Campo, TXBuilt 1999 · S/N 0706 N395CEBlue Bird Aviation LLC · Anchorage, AKBuilt 2007 · S/N 11647 N3971Dick Holdings LLC · Merritt Island, FLBuilt 2024 · S/N 14726 N397SUSouthern Utah University · Cedar City, UTBuilt 2003 · S/N 10063 N39CPWhirl'D Helicopters Inc · Sevierville, TNBuilt 2003 · S/N 10069 N39CSRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15002 N39GSAir Flight Enterprises Inc · South Daytona, FLBuilt 2007 · S/N 11624 N40014Ar Racing Inc · Catawba, NCNon-citizen corporation, flight hours not reportedBuilt 2025 · S/N 2825 N4004MRegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 2026 · S/N 2854 N4006VBaffin Resource Management LLC · Portland, TXBuilt 2025 · S/N 14918 N40079Atlantic Coast Helicopters Ltd · Ronkonkoma, NYBuilt 2025 · S/N 14869 N4007XRobinson Helicopter Co · Torrance, CABuilt 2025 · S/N 14910 N4008VDelta Leasing Inc · Chandler, AZBuilt 2026 · S/N 14990 N400HDSpitzer Helicopter LLC · Wilmington, DEBuilt 2008 · S/N 12220 N400PFH Richardson & Sons LLC · Ogdensburg, NYBuilt 2015 · S/N 13847 N400UHUhi Inc · Provo, UTBuilt 2014 · S/N 13650 N4010YRegistered aircraftBuilt 2025 · S/N 30103 N4011ASky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 30107 N4014ZAircraft Evolution LLC · Miami, FLBuilt 2025 · S/N 14862 N4015FCarolina Boulder And Stone LLC · Lewes, DEBuilt 2025 · S/N 14874 N4015GRobinson Helicopter Co · Torrance, CAS/N 2872 N40172Robinson Helicopter Co · Torrance, CAS/N 15051 N4017SRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15031 N4018XCrazy Horse LLC · Princeton, WVBuilt 2025 · S/N 14881 N401KWSoutheastern Tank & Tower Inc · Lake Park, GABuilt 2020 · S/N 14394 N4023YSky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 14866 N4026ECircle C Farms Inc · Bainbridge, GABuilt 2017 · S/N 14098 N4029PAugustus Aircraft LLC · Whitefish, MTBuilt 2017 · S/N 14094 N4034HBay Lux Ventures LLC · Tampa, FLBuilt 2017 · S/N 14075 N40363Raider LLC · Joplin, MOBuilt 2011 · S/N 2108 N4038WCharlie Delta Rotors Inc · Coral Gables, FLBuilt 2021 · S/N 14438 N403WAAviatech Inc · Tamarac, FLBuilt 2014 · S/N 13767 N4040Parker Helicopter LLC · Watsonville, CABuilt 2019 · S/N 30048 N4041FPine Bottom Aviation Services LLC · Martinsburg, PABuilt 2018 · S/N 14247 N4042QCharter Air Transportation LLC · Wayne, PABuilt 2021 · S/N 2658

Back to AD 95-26-05 R1