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.

N817ABHawaii Pacific Aviation Inc · Kailua Kona, HIS/N 1258 N818VHAltitude Aviatin Services LLC · Mountain Home, IDS/N 2297 N819GLRobinson Helicopter Co · Torrance, CAS/N 4966 N819TTHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1992 · S/N 2161 N820PTK & R Aviation LLC · Hollis, NHBuilt 2005 · S/N 3886 N821SHAero Leasing Inc · Brookings, ORBuilt 2005 · S/N 3774 N823MXEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 2573 N8244SExtreme Helicopter Service LLC · Alice, TXBuilt 1994 · S/N 2430 N824WSHampton Roads Charter Service · Chesapeake, VABuilt 2004 · S/N 3606 N82644Chandler Elijah J S · Pilot Mountain, NCBuilt 1988 · S/N 0760 N826GBerger Daniel · Edgewood, NMBuilt 2024 · S/N 4899 N826SASilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3755 N826SFN115vg LLC · Princeton, NJBuilt 2015 · S/N 4673 N827SCSpitzer Helicopter LLC · Wilmington, DES/N 4720 N827SH1 Acadiana Helicopters Company LLC · Cade, LABuilt 2005 · S/N 3780 N830JVeracity Aviation LLC · Seguin, TXBuilt 2007 · S/N 4236 N8312TRobinson Helicopter Co · Torrance, CABuilt 1994 · S/N 2452 N83130Registered aircraftBuilt 1994 · S/N 2426 N8313EShevah Avi · New Milford, CTS/N 2463M N8315RJnl Aviation LLC · Orlando, FLBuilt 1994 · S/N 2475 N8316DMarinephoto Helicopter LLC · Rehoboth Beach, DEBuilt 1994 · S/N 2481M N8316NN8316n LLC · Rehoboth Beach, DES/N 2480 N831SHHutchison Eugene W · Armagh, PABuilt 2005 · S/N 3793 N8320AMendez Leonel Jr · Corpus Christi, TXBuilt 1995 · S/N 2510 N8321PSmoketown Helicopters LLC · Smoketown, PABuilt 1995 · S/N 2538 N8323BMidcoast Helicopter Services Inc · La Ward, TXBuilt 1995 · S/N 2535 N8324USyren David N · Anchorage, AKBuilt 1995 · S/N 2570M N8328UHale Larry D · Charlotte, NCBuilt 1995 · S/N 2567 N8332TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1996 · S/N 2587 N8339QDingler Isaac C · Langtry, TXBuilt 1996 · S/N 2633 N833DPShier Aviation Corp DBA · San Diego, CABuilt 2005 · S/N 3797 N8340SHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1996 · S/N 2640 N8341NCr Helicopters Inc · Nashua, NHS/N 2656 N8346KRegistration Pending · Sonora, TXRegistration pendingS/N 2681 N8348UAnjum Hohammad A · Melrose Park, ILS/N 2686 N834SHSmith Helicopters Inc · Cotulla, TXBuilt 2005 · S/N 3800 N8350MVortex Leasing LLC · Racine, WIBuilt 1997 · S/N 2665 N8353MCrosswind Leasing LLC · Prescott, AZS/N 2666M N8355AEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N 2714 N8356REmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N 2729 N8358FHolt Helicopters Inc · Uvalde, TXBuilt 1997 · S/N 2736 N8358MSky Blue Holdings LLC · Park City, UTBuilt 1996 · S/N 2651 N835SHBuell Travis W · Harper, TXS/N 3801 N8360RSan Diego Community College District · San Diego, CABuilt 1997 · S/N 2772 N8362LEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N 2642 N8364QBlinn Philipp Randy · Priest River, IDBuilt 1982 · S/N 0311 N8365EAlpine Aviation LLC · Oasis, IDS/N 2654 N83666Baugh Aviation Inc · Lebanon, TNBuilt 1982 · S/N 0314 N8371CEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N 2751 N8372GSpitzer Helicopter LLC · Woodland Hills, CABuilt 1998 · S/N 2782

Back to AD 88-26-01 R2