Skip to content

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.

N74343Hindes Philip DBA · Charlotte, TXBuilt 2004 · S/N 3756 N74347Spitzer Helicopter LLC · Woodland Hills, CABuilt 2005 · S/N 3759 N743DPVeracity Aviation LLC · Seguin, TXBuilt 2003 · S/N 3429 N74426Spitzer Helicopter LLC · Woodland Hills, CABuilt 2006 · S/N 4017 N744ESUsaircraft Inc · Newark, DEBuilt 1993 · S/N 2319 N74541Premier Helicopters LLC · Carson City, NVBuilt 2005 · S/N 3865 N74557N74557 LLC · Kissimmee, FLBuilt 2005 · S/N 3900 N74564November Alpha LLC · Dover, DEBuilt 2005 · S/N 3908 N74574Burrell Helicopters LLC · D Hanis, TXBuilt 2005 · S/N 3913 N74583Mile High Carpet Rides LLC · Dover, DEBuilt 2005 · S/N 3923 N74597Airman Helicopter Inc · Fort Lauderdale, FLBuilt 2005 · S/N 3927 N74606Spitzer Helicopter LLC · Woodland Hills, CABuilt 2005 · S/N 3937 N74709Schulz Vince · Hannibal, MOBuilt 2005 · S/N 3947 N74774Alyeska Helicopters LLC · Girdwood, AKBuilt 2005 · S/N 3967 N74810Civic Helicopters Inc · Carlsbad, CABuilt 2005 · S/N 3979 N74815Registration Pending · Canyon Lake, TXRegistration pendingS/N 3980 N74864Defenbaugh Matthew J · Biggsville, ILBuilt 2005 · S/N 3997 N748HHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1748 N74GNStuckey Connections LLC · Magnolia, TXBuilt 2018 · S/N 4768 N7507GEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3240 N7507NKinzie Hon · Anchorage, AKBuilt 2002 · S/N 3321 N7510EShier Aviation Corp DBA · San Diego, CABuilt 2002 · S/N 3380 N7510UCrop Doctor Aviation Inc · Hill City, KSBuilt 2003 · S/N 3472 N7512CAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2003 · S/N 3484 N7514WMagnum Leasing LLC · Waterford, MIBuilt 2004 · S/N 3706 N7517UNg&C Trucking LLC · Carrollton, GAS/N 3510 N7517WVaquillas Trading Co Ltd · Aguilares, TXBuilt 2003 · S/N 3406 N7518YAlba Aviation Services Inc · Scottsdale, AZBuilt 2003 · S/N 3438 N7521ZVeracity Aviation LLC · Seguin, TXBuilt 2005 · S/N 3810 N7526PSpitzer Helicopter LLC · Woodland Hills, CABuilt 2003 · S/N 3407 N7528LThompson Helicopters LLC · Uvalde, TXBuilt 2004 · S/N 3595 N7529PEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2004 · S/N 3618 N7529ZNielsen Aircraft Corp · Los Angeles, CABuilt 2004 · S/N 3628 N7532RSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3554 N7532SSpitzer Helicopter LLC · Woodland Hills, CABuilt 2004 · S/N 3630 N7533DFranz Barrett C · Bay City, TXBuilt 2004 · S/N 3643 N7534LNovember Alpha LLC · Los Angeles, CABuilt 2004 · S/N 3650 N7536BAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3688 N754CTAoa Aviation Service LLC · Waxhaw, NCS/N 1981 N755SHBobby C Johns Family LLC · Floresville, TXS/N 4163 N7679HSummerskyz Inc · Urbana, ILBuilt 2004 · S/N 3540 N767ERJet Stream Jockey LLC · Venice, CABuilt 2005 · S/N 3956 N7683HNovember Alpha LLC · Dover, DEBuilt 2005 · S/N 3885 N7686HTotal Flight Aircraft Leasing LLC · Apex, NCS/N 4348 N7717ZTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 2002 · S/N 3373 N771SHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 3543 N772HASmith Jason E · Calliham, TXBuilt 2007 · S/N 4179 N772SHLawrence John · Anderson, CABuilt 2004 · S/N 3546 N774HAExtreme Helicopter Service LLC · Alice, TXBuilt 1989 · S/N 1084 N776SHExplore Helicopters LLC · Lexington, ALBuilt 2004 · S/N 3552

Back to AD 88-26-01 R2