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.

N777UHRobinson Helicopter Company Inc · Torrance, CABuilt 2004 · S/N 3548 N7780HSummerskyz Inc · Urbana, ILBuilt 1997 · S/N 2682 N778FHuff Joe R Sr · Avinger, TXBuilt 2016 · S/N 4019 N778MRSpitzer Helicopter LLC · Woodland Hills, CABuilt 2001 · S/N 3201 N779SHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 3591 N77UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2008 · S/N 4398 N7816RRays Aircraft Sales LLC · Tolland, CTBuilt 2001 · S/N 3291 N781SHNorth American Rotorcraft LLC · Santa Rosa, CABuilt 2004 · S/N 3613 N782SHJtc Aviation LLC · Nashville, TNBuilt 2004 · S/N 3616 N783SHKmc Aircraft Leasing LLC · Spanish Fork, UTBuilt 2004 · S/N 3617 N786SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3626 N788SHSouthwest Technology Center School Dist No. 27 · Altus, OKBuilt 2004 · S/N 3631 N790SHMichael Mollere Inc · Marion, TXBuilt 2004 · S/N 3636 N791SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3637 N795SHLange Helicopters Inc · San Angelo, TXS/N 3728 N7989HJtc Aviation LLC · Nashville, TNBuilt 1994 · S/N 2453 N798MGKeepem Turnin LLC · Sevierville, TNS/N 2704 N79FCSulpher Creek Helicopters LLC · George West, TXBuilt 2007 · S/N 4137 N80025South Florida Helicopters Inc · Indiantown, FLS/N 0912 N800BPJet Fighter Sales LLC · Rehoboth Beach, DEBuilt 1990 · S/N 1263 N80140Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1989 · S/N 1030 N80142Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1989 · S/N 0992 N80156Helistream Inc · Kalispell, MTBuilt 1989 · S/N 0993 N8015BElite Choppers Nc LLC · Winston Salem, NCS/N 0974 N8025XCivil Aviation Leasing Ltd · Wilmington, DEBuilt 1989 · S/N 1048 N802WHMansfield Heliflight · Milton, VTS/N 0802 N8038AEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1989 · S/N 1025 N8039RFlying Services Inc · Wilmington, DEBuilt 1989 · S/N 1052M N803EHContinental Helicopters Inc · Sheffield, TXS/N 2388 N80407N80407 LLC · Rehoboth Beach, DEBuilt 1989 · S/N 1038 N8042BSummerskyz Inc · Saint Joseph, ILBuilt 1989 · S/N 1110 N8043JHartland Helicopters LLC · Edinburg, TXS/N 1102 N8043UClassic Banjo LLC · Richmond, KYBuilt 1989 · S/N 1062 N8045KEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1989 · S/N 1141 N805EHPope James D · Lewiston, IDS/N 1907 N8062HHelistream Inc · Kalispell, MTBuilt 1989 · S/N 1172 N8062QN8062q LLC · Fairgrove, MIBuilt 1989 · S/N 1227 N8062UCullman Rotocraft Inc · Vinemont, ALBuilt 1989 · S/N 1182 N8063ZUS Helicopter Services Inc · Rochester Hills, MIBuilt 1989 · S/N 1207 N80645N80645 LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2304M N8066UBayphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1990 · S/N 1273 N806EHFisher Air LLC · Cardington, OHBuilt 1990 · S/N 1452 N8072XHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1990 · S/N 1493 N807EHLindsey Daniel Rey · Clovis, NMS/N 1242 N8080YEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1356 N808HSShizuka Saito Inc · Wilmington, DES/N 2803 N8094QSpitzer Helicopter LLC · Woodland Hills, CABuilt 1993 · S/N 2385 N8142LWesellairplanes Com Inc · Wilmington, DEBuilt 1994 · S/N 2416 N8153CHelileasing Inc · Las Vegas, NVBuilt 1991 · S/N 1809 N815EHBuell Travis · Harper, TXS/N 2431

Back to AD 88-26-01 R2