Skip to content

Registered aircraft · 22,416

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

N8575WSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842410 N8576WHaynes Edward · Snohomish, WABuilt 1963 · S/N 28-10088 N8576XSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842411 N8577CWaldmiller Robert Joseph · Rosamond, CABuilt 1976 · S/N 32-7740001 N8577WM97west LLC · Fargo, NDBuilt 1963 · S/N 28-10089 N8577YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842412 N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152 N8578NWells Canda R · Holdrege, NEBuilt 1971 · S/N 28-7110010 N8578ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842413 N8579NWillaero LLC · Union City, TNBuilt 1971 · S/N 28-7105133 N8579WWessler George H · Dunedin, FLBuilt 1963 · S/N 28-10091 N857GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881068 N857PUTrustees Of Purdue University · West Lafayette, INS/N 2881330 N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224 N857SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881741 N857WAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 3257355 N8580ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842414 N8580NA1 Aviation LLC · Lewis, DEBuilt 1969 · S/N 28-11317 N8581ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020159 N8581JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842415 N8582CCurran Aviation Services LLC · Yorba Linda, CABuilt 1976 · S/N 28R-7635166 N8582ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020160 N8582MSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844160 N8583BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020201 N8583NSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844161 N8584DSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020202 N8584TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844162 N8584WSawyer Clissie M · North Platte, NEBuilt 1963 · S/N 28-10096 N8585HSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020232 N8585NLowe Scott S · San Diego, CABuilt 1971 · S/N 28-7110005 N8585ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844163 N8586ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844164 N8586JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020233 N8587KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844165 N8587LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020234 N8587TJet Winds LLC · Gulf Shores, ALBuilt 1972 · S/N 32-7340022 N8588BSavage James B · Gibsonia, PABuilt 1975 · S/N 28-7525332 N8588PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020235 N8588WAndree Alfred L · Homer, AKBuilt 1963 · S/N 28-10100 N8589SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020249 N8589WCoke Roger T · Clarksville, INS/N 28-10101 N858PUTrustees Of Purdue University · West Lafayette, INS/N 2881331 N858SMLoomer Donald W · Williston, NDBuilt 1982 · S/N 28-8290079 N858SRCharlie 25 LLC · Cedar Falls, IAS/N 32R-8329037 N8590ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020250 N8591CSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2026 · S/N 28020256 N8592ERegistration Pending · Vero Beach, FLRegistration pendingBuilt 2026 · S/N 28020257 N8592NSluder George L · Willard, NCBuilt 1971 · S/N 28-7125434 N8593GPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020274 N8593WFerrin Scott Ellis · Provo, UTBuilt 1963 · S/N 28-10105

Back to AD 87-08-08 R3