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.

N839RMN839rm LLC · Otsego, MNBuilt 2013 · S/N 2327 N83PGRb Aviation Enterprise LLC · Palm City, FLBuilt 2012 · S/N 13341 N840CSMiller Ashley M · Lima, OHBuilt 1997 · S/N 0326 N841AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2003 · S/N 1317 N843AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2000 · S/N 0835 N843FRC4l Helicopters LLC · Myrtle Beach, SCBuilt 1999 · S/N 0562 N844AFAltitude Assets LLC · Dover, DEBuilt 2007 · S/N 11648 N844AKQuicksilver Air Inc · Fairbanks, AKBuilt 2013 · S/N 13489 N844ATRegistered aircraftBuilt 2022 · S/N 14565 N844BHBlack Hills Aviation Leasing LLC · Rapid City, SDBuilt 2025 · S/N 14828 N844BSAerometrics Research LLC · Lewes, DEBuilt 2013 · S/N 13468 N844DTSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1999 · S/N 0622 N844DWNamo Aero Inc · Wilmington, DEBuilt 2008 · S/N 12400 N844HAHetrick Air Services Inc · Lawrence, KSBuilt 2025 · S/N 14935 N844HJRobinson Helicopter Co · Torrance, CAS/N 15053 N844KCDrew Helicopters LLC · Annona, TXBuilt 2008 · S/N 12603 N844MAFront Range Heli Inc · Erie, COBuilt 2011 · S/N 2107 N844MBVictor Foxtrot LLC · Scott City, KSBuilt 2014 · S/N 13766 N844RBBates Show Sales Staff Inc · Venice, FLBuilt 2022 · S/N 14545 N844SBPostula William · Tomball, TXBuilt 2021 · S/N 14476 N844VBPnr Holdings Bravo LLC · Baltimore, MDBuilt 2017 · S/N 14132 N848DJMahc Properties LLC · Cedar Key, FLBuilt 2007 · S/N 1719 N849WYYerxa W A DBA · Colusa, CABuilt 2012 · S/N 2253 N850DFFlying J Services LLC · Jourdanton, TXBuilt 2001 · S/N 1019 N852SBPowerhouse Dealer Services LLC · Charlotte, NCBuilt 2025 · S/N 14858 N8531SIrving Barrett · Casa Grande, AZBuilt 2006 · S/N 11433 N853SBWjc Aviation LLC · Englewood, FLBuilt 2025 · S/N 14860 N854WSMn Helicopters Inc · Minneapolis, MNBuilt 2005 · S/N 10844 N855LSAir First LLC · Kalispell, MTBuilt 1996 · S/N 0260 N857AKOld City Helicopter Sales LLC · St Augustine, FLS/N 1145 N857HLHelicrop LLC · Menlo, IABuilt 2005 · S/N 11010 N857RDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 30109 N858ZStearman Air Tours Inc · Gatesville, NCBuilt 2005 · S/N 10712 N859LERegistration Pending · Lexington, KYRegistration pendingBuilt 2026 · S/N 14995 N860MPInternational Air Services Inc Trustee · Carson City, NVBuilt 2023 · S/N 14608 N8611CWateractive43 LLC · Auburn, CABuilt 2021 · S/N 14495 N861MPNovember Alpha LLC · Dover, DEBuilt 2023 · S/N 14646 N862MMRhc3 LLC · Myrtle Beach, SCBuilt 2006 · S/N 11350 N862MRHeli-Spray LLC · Avalon, TXBuilt 2004 · S/N 10420 N863DCVredenburg John D III · Tucson, AZBuilt 2006 · S/N 11090 N863MPOverlook Air LLC · Lexington, KYBuilt 2023 · S/N 30098 N865PBAnthelian Helcopters · Long Beach, CAS/N 10865 N866JSNine Six Livestock Co · Sterling City, TXBuilt 2020 · S/N 14406 N866MPA&L Enterprises LLC · Maiden Rock, WIBuilt 2021 · S/N 14435 N866NSSullivan Joseph E 3rd · North Conway, NHBuilt 2022 · S/N 14553 N866SRLouisville Helicopter LLC · Anchorage, KYBuilt 2012 · S/N 2258 N867MPMainstream Aviation LLC · Benton, KYBuilt 2022 · S/N 14508 N868MPBh Aviation LLC · Jackson, TNBuilt 2022 · S/N 14540 N869RMPremier Legacy Aviation LLC · Lewes, DEBuilt 2009 · S/N 12688 N86JDBurton Nicholas D · Clinton, TNBuilt 2004 · S/N 10539

Back to AD 95-26-05 R1