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.

N821JPFirst Air Associates LLC · Las Vegas, NVS/N 1848 N821MRMtm Aviation Inc · Corona, CABuilt 2024 · S/N 14764 N822FHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2005 · S/N 10860 N823TCSky Solutions LLC · Detroit, MIBuilt 2008 · S/N 12167 N824AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2001 · S/N 0975 N824AMHolt Helicopters Inc · Uvalde, TXBuilt 2012 · S/N 13400 N824DKWarner Farm Corp · Onida, SDBuilt 2006 · S/N 11117 N824RFFlint Hills Helicopter LLC · Sabetha, KSBuilt 2024 · S/N 14786 N824TELhr44 Aviation LLC · Honey Brook, PAS/N 2428 N824TFRegistered aircraftBuilt 2018 · S/N 2534 N825BN825b LLC · Port Arthur, TXBuilt 2005 · S/N 10651 N825TJTakeflight LLC · American Fort, UTBuilt 2003 · S/N 10103 N825VJLite Flight Inc · Chatsworth, CAS/N 10668 N826CBBrazos River Helicopters LLC · Haskell, TXBuilt 2006 · S/N 11288 N826CLC S Flying Service LLC · Carlsbad, NMBuilt 2012 · S/N 13307 N827FKSkyvibes LLC · Abingdon, VABuilt 2004 · S/N 1417 N827LSStone James Ellis · Knoxville, TNBuilt 2007 · S/N 1752 N828AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2007 · S/N 1689 N828EJWhirld Helicopters Inc · Sevierville, TNS/N 10457 N828RDCedar Ridge Aviation LLC · Knox City, TXBuilt 2002 · S/N 1254 N829AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2000 · S/N 0895 N829DBBlodgett Gary R · Wellington, FLBuilt 2012 · S/N 13229 N829KRegistration Pending · Crossett, ARRegistration pendingS/N 10971 N829RPRjp66 LLC · Yaphank, NYBuilt 2025 · S/N 14846 N830AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2000 · S/N 0838 N830FMBlack Dog Helicopters LLC · Ocean Isle Beach, NCBuilt 2010 · S/N 12989 N831HNovember Alpha LLC · Dover, DEBuilt 2007 · S/N 11791 N831VATravel Systems LLC · Boerne, TXBuilt 2013 · S/N 13477 N8328LArrowhead Helicopter Services LLC · Jourdanton, TXBuilt 1995 · S/N 0210 N832AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2003 · S/N 1324 N8333ZMbaa Holding LLC · Myrtle Beach, SCBuilt 1996 · S/N 0249 N8336XConway Brian R · Fallbrook, CABuilt 1996 · S/N 0228 N8336ZGreene Tom · Mesquite, NVBuilt 1996 · S/N 0262 N8339GAudia Roger S · Pennington Gap, VABuilt 1996 · S/N 0243 N8348XBas Part Sales LLC · Greeley, COBuilt 1997 · S/N 0332 N8349RCsi Flight Services LLC · Mcminnville, ORBuilt 1997 · S/N 0336 N8351NDel Rio Aviation Inc · Paso Robles, CABuilt 1997 · S/N 0411 N835AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2002 · S/N 1221 N8361MJetcopters LLC · Lewes, DEBuilt 1996 · S/N 0303 N8361XBusy Bee Helicopter LLC · Paulding, OHBuilt 1998 · S/N 0431 N8362NAtlantic Aviation LLC · Stevensville, MDBuilt 1998 · S/N 0428 N8362STaylor Robert T · Chehalis, WAS/N 0429 N8363NHeliflights LLC · Rahway, NJS/N 0442 N8364ZN7535z LLC · Raleigh, NCBuilt 1998 · S/N 0426 N8365QTtwn Media Networks LLC · New York, NYBuilt 1998 · S/N 0423 N8369FTtwn Media Networks LLC · New York, NYBuilt 1998 · S/N 0358 N836AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2007 · S/N 1691 N8372HEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N 0387 N8372KYang Chi · Lafayette, COBuilt 2001 · S/N 1099 N838BPSpitzer Helicopter LLC · Woodland Hills, CAS/N 1108

Back to AD 95-26-05 R1