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.

N44NVRegistration Pending · Williston, NDRegistration pendingS/N 11800 N44PAN44pa LLC · Boca Raton, FLBuilt 2021 · S/N 14493 N44SKCm3 LLC · North Las Vegas, NVBuilt 2004 · S/N 10534 N44TGBlue Water Flying Services LLC · Lumberton, TXS/N 0509 N44TWRotor Leasing LLC · Indianapolis, INBuilt 2025 · S/N 14824 N44TXRobinson Helicopter Co · Torrance, CAS/N 15018 N44UBPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 11194 N44UKN44uk Partners LLC · Burlington, WABuilt 2005 · S/N 10969 N44XBBrennon Aviation LLC · North Fort Myers, FLBuilt 2002 · S/N 1215 N44XCSendero Helicopters LLC · Bandera, TXBuilt 2006 · S/N 11227 N44XHPelican Island Air Leasing Inc · Bryson City, NCBuilt 2014 · S/N 13651 N44YAAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2004 · S/N 10261 N44YDYule Development Co Inc · Newton Center, MABuilt 2007 · S/N 11826 N44YNG A Clipper Helicopter Inc Trustee · Wilmington, DEBuilt 2003 · S/N 10110 N450DLBay Larry · San Diego, CABuilt 2003 · S/N 10236 N4510TNorthstar Holdings LLC · Anchorage, AKBuilt 2011 · S/N 13085 N451ATMaxflight Helicopter Services Inc · Kissimmee, FLBuilt 2021 · S/N 2636 N451LLRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 15019 N451WSG&S Property Management LLC · Saint Ignatius, MTS/N 10338 N4520XFlorida Coast To Coast Helicopters Inc · Pompano Beach, FLBuilt 2009 · S/N 12873 N4529JStar Quest LLC · Wilmington, DEBuilt 2009 · S/N 12683 N4529UDavis Jeremy S · Port Alsworth, AKBuilt 2009 · S/N 12708 N4529XRyan Flatt Cattle Co · Marfa, TXS/N 12753 N452MEMagnum Leasing LLC · Waterford, MIBuilt 2009 · S/N 12755 N4537GNovember Alpha LLC · Dover, DEBuilt 2009 · S/N 12535 N4537JTurkey Holler LLC · Knox City, TXS/N 12767 N4538GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2009 · S/N 2036 N454SHHillcrest Aircraft Co · Lewiston, IDBuilt 2005 · S/N 10672 N454WMSmith Aviation LLC · Missoula, MTBuilt 2024 · S/N 14750 N454WTAce Flight LLC · Houma, LABuilt 2001 · S/N 1042 N4567Amigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11033 N456AZOne Point 7 Air LLC · Ravensdale, WAS/N 13794 N456JJRichardson Ruben R · Yuma, COBuilt 2019 · S/N 14314 N456MHQuality Coal LLC · Mount Sterling, KYBuilt 2011 · S/N 13207 N456MLLangbehn Land & Cattle Co Inc · Wolsey, SDBuilt 2016 · S/N 13970 N456TGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 11136 N457CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2012 · S/N 13302 N457CWRockin Mc Helicopter Services LLC · Missoula, MTBuilt 2013 · S/N 13542 N457WTBlair Aviation LLC · Essex, MOBuilt 2008 · S/N 12480 N458DBPelican View LLC · Slidell, LABuilt 2018 · S/N 14241 N458LTN87bb LLC · Monroe, NCBuilt 2024 · S/N 14803 N458SGCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 10458 N45CABas Part Sales LLC · Greeley, COBuilt 2012 · S/N 2242 N45HCChavi LLC · Fredericksburg, TXS/N 11326 N45PGRaven Aircraft LLC · Camas, WAS/N 0991 N45SLWebb Aviation LLC · Watonga, OKBuilt 2008 · S/N 12139 N460SAN460sa LLC · Brea, CABuilt 2006 · S/N 11558 N460TJVertical Ventures Aviation LLC · Franconia, NHBuilt 2012 · S/N 13377 N462BAElkhorn Aviation Inc · Baker City, ORBuilt 2008 · S/N 12265 N463DSSalisbury David W · Gettysburg, PABuilt 2005 · S/N 1518

Back to AD 95-26-05 R1