Registered aircraft · 816

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:88-26-01-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-26-01-R2') 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:88-26-01-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-26-01-R2')
  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:88-26-01-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-26-01-R2')
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.

N290SHParker Helicopter LLC · Watsonville, CABuilt 2007 · S/N 4186 N292BAPic LLC · Catano, PRBuilt 2016 · S/N 4717 N292PDBarge Photo Helicopter LLC · Rehoboth Beach, DEBuilt 1995 · S/N 2498M N299TCBerg Ted D · Mabelvale, ARBuilt 1997 · S/N 2725 N29EHRotary Run LLC · Zoar, OHBuilt 2005 · S/N 3889 N29NEYankee Helicopters LLC · Plainville, CTBuilt 1987 · S/N 0691M N3004XNovember Alpha LLC · Dover, DEBuilt 2007 · S/N 4152 N300JMEmerald City Aircraft Leasing LLC · Port Orchard, WABuilt 2005 · S/N 3805 N3019SSmith Jason E · Calliham, TXBuilt 2007 · S/N 4150 N301BPPrecision Aviators LLC · Iuka, ILBuilt 1991 · S/N 1983 N301HEN301he LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2382M N301RWRegistered aircraftBuilt 2008 · S/N 4264 N301SHSpitzer Helicopter LLC · Wilmington, DEBuilt 2021 · S/N 4842 N3035FUtah State University · Logan, UTBuilt 2007 · S/N 4169 N3040KLeading Edge Flight Academy LLC · Bend, ORBuilt 2007 · S/N 4165 N304QAAltus Aviation Managment · Las Vegas, NVNon-citizen corporation, flight hours not reportedBuilt 2015 · S/N 4694 N304RQSpitzer Helicopter LLC · Wilmington, DEBuilt 2018 · S/N 4767 N3055NAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2007 · S/N 4168 N305NKKamasano LLC · Highland, CABuilt 2001 · S/N 3163 N3067LT&G Aviation Services LLC · Temple, TXBuilt 2007 · S/N 4191 N3068NAlpine Air Aviation LLC · West Haven, UTBuilt 2007 · S/N 4202 N3070SMat-Su Helicopter Training LLC · Wasilla, AKBuilt 2007 · S/N 4217 N307RBHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1999 · S/N 3007 N3082CJets To Helis LLC DBA · Chandler, AZBuilt 2007 · S/N 4231 N3086TAlba Aviation Services Inc · Scottsdale, AZBuilt 2006 · S/N 4047 N3092XSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2006 · S/N 4043 N30CHSale Reported · Maiden, NCSale reported, pending cancellationBuilt 2026 · S/N 4944 N3104UNelson Christopher · Crown Point, INBuilt 2006 · S/N 4061 N310KDEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 3028 N31192Silverhawk Aviation Academy LLC · Caldwell, IDBuilt 2022 · S/N 4868 N313DDAlpine Air Aviation LLC · West Haven, UTBuilt 2001 · S/N 3226 N31485Unusual Attitudes LLC · Bates City, MOBuilt 2006 · S/N 4088 N3155YBult Equipment LLC · Monee, ILBuilt 2006 · S/N 4095 N315JFFuller Jon A · Goliad, TXBuilt 2008 · S/N 4295 N3179AEsslinger Jamie · Valley Center, CABuilt 2006 · S/N 4100 N3189ZSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2007 · S/N 4105 N31HJAero Tech Academy Inc · Redlands, CANon-citizen corporation, flight hours not reportedBuilt 1986 · S/N 0615 N31VGTita Enterprises LLC · Apex, NCBuilt 2004 · S/N 3551 N31VHAmy Inc · Wilmington, DEBuilt 2005 · S/N 3966 N322GEPierce Michael W · Leitchfield, KYS/N 0934 N322MLAshcraft Aviation LLC · Bay City, TXS/N 3572 N322RHRobinson Helicopter Co · Torrance, CABuilt 2026 · S/N 4952 N32ADRobinson Helicopter Co · Torrance, CABuilt 1977 · S/N 0002 N32SHFuller Jon A · Goliad, TXS/N 0599 N32VGRegistered aircraftBuilt 1997 · S/N 2773 N32WTEdwards Anthony C · Weaverville, CABuilt 1990 · S/N 1495 N330DDUtah State University · Logan, UTBuilt 2002 · S/N 3401 N332MDGuidance Helicopters Inc · Prescott, AZBuilt 1999 · S/N 2991 N333PHJ&L Management Group LLC · Lewes, DEBuilt 1993 · S/N 2326 N333PJHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2005 · S/N 3804

Back to AD 88-26-01 R2