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.

N155MBEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1550 N155SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4155 N156SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4159 N158SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4167 N159SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4171 N160NHLouisville Helicopter LLC · Louisville, KYS/N 1429 N163SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4175 N164LEStraitgate Performance LLC · Mesa, AZBuilt 2001 · S/N 3164 N165JCSmoketown Helicopters LLC · Smoketown, PAS/N 0146 N166ARebel Blade Aviation Inc · Helendale, CAS/N 3167 N166DKBranscum Jill Kubecka · Edna, TXBuilt 2019 · S/N 4799 N16GAGuidance Helicopters Inc · Prescott, AZBuilt 2001 · S/N 3211 N16HFUniversal Aviators Academy Inc · El Monte, CABuilt 1988 · S/N 0778 N1777VFlying Colors Airparts Inc · Leesburg, FLBuilt 1987 · S/N 0623 N177SRTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2001 · S/N 3275 N182ASAltus Aviation Management · San Dimas, CABuilt 1997 · S/N 2676 N183LELeading Edge Flight Academy LLC · Bend, ORBuilt 2007 · S/N 4183 N184SHSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2007 · S/N 4205 N186SHContinental Helicopters Inc · Sheffield, TXBuilt 2007 · S/N 4209 N187MHP&V Howard Enterprises LLC · Angleton, TXBuilt 2002 · S/N 3361 N190HMn Helicopters Inc · Minneapolis, MNBuilt 2007 · S/N 4215 N193GCTnt Machining Company LLC · Russell, KYBuilt 1990 · S/N 1549 N194HCCalifornia Spyder LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1955M N194KCHallmark University Inc · San Antonio, TXBuilt 1991 · S/N 1989 N194LELeading Edge Aviation Inc · Bend, ORBuilt 2006 · S/N 4094 N196JGNine Six Livestock Co · Sterling City, TXBuilt 1999 · S/N 2909 N197SHSierra Hotel LLC · Gardena, CABuilt 2007 · S/N 4197 N199AHAtlantic Aviation International Inc · Lewes, DES/N 1801 N19MESims Hollon M · Lithonia, GAS/N 0681 N19UPBergeson Michael · Rocklin, CABuilt 2012 · S/N 4574 N200UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2014 · S/N 4634 N20430Jets To Helis LLC DBA · Chandler, AZBuilt 1989 · S/N 1236 N204KKLofstrom Ashley N · Wasilla, AKBuilt 1989 · S/N 1232 N209SHPark West Air LLC · Coraopolis, PABuilt 2007 · S/N 4256 N211DMBuell Travis · Harper, TXS/N 0542 N211MHWings Over Texas Holdings LLC · Denton, TXS/N 2082 N211SMDingler Larry G · Dryden, TXBuilt 1991 · S/N 2011 N214RBS And S 1165 Investments LLC · Wimberley, TXBuilt 1992 · S/N 2114 N216ABAarow Aircraft Leasing LLC · Dallas, TXS/N 0663 N220AGPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 3664 N220FTTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1989 · S/N 1093 N220WMUtah Helicopter LLC · Spanish Fork, UTBuilt 2005 · S/N 3815 N2216KRugged Country Helicopters LLC · Cedar City, UTBuilt 1989 · S/N 0998 N221HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1992 · S/N 2197 N221HLSouth Florida Helicopters Inc · Indiantown, FLS/N 0723 N221KCSundance Aero LLC · Mertzon, TXBuilt 2001 · S/N 3180 N221WMUtah Helicopter LLC · Spanish Fork, UTBuilt 2008 · S/N 4285 N221ZTSg Aviation Inc · Clearwater Beach, FLBuilt 2002 · S/N 3311 N2223PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 2962 N2225CCashwell Kenneth E · The Villages, FLBuilt 2025 · S/N 4917

Back to AD 88-26-01 R2