Skip to content

Registered aircraft · 72,007

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N35031Granite Bay Properties LLC · Nicholasville, KYS/N 17702167 N35032Galten Banning D · Willits, CABuilt 1974 · S/N 17702168 N35033Aero Pilots Inc · Norman, OKBuilt 1974 · S/N 17702169 N35034Prime Michael F · Enumclaw, WAS/N 17702170 N35036Alpha Kilo Aviation LLC · Oxford, MDBuilt 1974 · S/N 17702171 N3503KRunyon Michael · Charlotte, NCS/N 28-23591 N3503ZMcmath Don · Collinsville, OKBuilt 1960 · S/N 22-7398 N35041Black Alan D H · Mariposa, CABuilt 1974 · S/N 17702172 N35044Slo Flight LLC · San Luis Obispo, CABuilt 1974 · S/N 17702173 N35047Leps Jeffrey W · Frisco, NCBuilt 1974 · S/N 17702174 N3504ZHeadrick John E · Eolia, MOS/N 22-7399 N35050Wings Aloft LLC · Pierre, SDBuilt 1974 · S/N 17702176 N35053Tj Flight LLC · Cypress, TXBuilt 1974 · S/N 17702178 N35056Walters Craig S · Lake City, FLS/N 17702179 N3505MMountain Green Aviation LLC · Morgan, UTBuilt 1947 · S/N 12-2353 N3505XSiegel Craig A · Tucson, AZBuilt 1966 · S/N 670043 N35061Delucia Dennis DBA · Franklin, PAExpired dealer, pending cancellationBuilt 1974 · S/N 17702182 N35063Purdue Aviation LLC · West Lafayette, INBuilt 2001 · S/N 172S8878 N35065Newman Richard T · Seattle, WAS/N 17702184 N35068Monroe Robert S · Oceanside, CABuilt 1974 · S/N 17702186 N35069Duffek John C · Hillsborough, NJBuilt 1974 · S/N 17702187 N3506QEjair LLC · Shelburne, VTBuilt 2002 · S/N 18281108 N3506TBaron Logistics LLC · Metairie, LABuilt 2001 · S/N 172S8962 N3506XBevers David A · Colfax, CABuilt 1966 · S/N 670044 N3506YCascade Commodities LLC · Saint Paul, MNBuilt 2001 · S/N T20608311 N35074Nanny Stephen D · Eagar, AZBuilt 1974 · S/N 17702190 N35076Bishop William M · Rougemont, NCBuilt 1974 · S/N 17702191 N3507FAerial Oklahoma LLC · Oklahoma City, OKBuilt 1967 · S/N 17700608 N3507ZLaw T Wayne · West Point, UTBuilt 1960 · S/N 22-7402 N35083J3 Enterprises LLC · Colquitt, GABuilt 1974 · S/N 17702196 N35086Robison David P · Spencer, IABuilt 1974 · S/N 17702198 N35088Apple Jeffrey G · Sheridan, INBuilt 1974 · S/N 17702199 N35089Caldwell Enterprise Inc · Grand Prairie, ILS/N 17702200 N3508KTurnquest Alexis A · West Valley City, UTS/N 28-23594 N3508PJones Casey A · Princeton, KSBuilt 1955 · S/N 22-3258 N3508XPietrs Robert A · Madison, ALS/N 670046 N3509Voigt Lauren · Jber, AKBuilt 2021 · S/N KA19362435 N35091Kinard Taylor Layne · Collierville, TNBuilt 1974 · S/N 17702202 N35092Iasco Flight Training Inc · Redding, CABuilt 2001 · S/N 17281044 N35093Staples Clint B · Nemo, TXBuilt 1974 · S/N 17702204 N35099Edwards Rex W · Monroe, NCBuilt 1974 · S/N 17702205 N3509QChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8835 N350ARAbode Construction Inc · Marion, IABuilt 1990 · S/N 4622109 N350ASSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 40.343 N350BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881691 N350CAMajors Donald G Jr · Cave Creek, AZBuilt 2002 · S/N 3257279 N350DFForton Donald E · Columbus, MIBuilt 1997 · S/N 01 N350DMR&J Helicopters LLC · Port Byron, ILBuilt 1997 · S/N 0366 N350GSmith Michael J · Brandon, MSBuilt 1993 · S/N 78 N350GBCarto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052136

Back to AD 87-10-06 R1