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.

N9130WCanyon Aviation Mt LLC · Kalispell, MTBuilt 1966 · S/N 28-10748 N9131KThompson Flying Club Inc · New Cumberland, PABuilt 1976 · S/N 28-7690220 N9131WPrunty Joseph · Weaverville, CABuilt 1966 · S/N 28-10749 N9132JPortneuf Holdings LLC · Chubbuck, IDBuilt 1966 · S/N 28-3182 N9132KMcwhorter Mark Edward · Flower Mound, TXBuilt 1976 · S/N 28-7690221 N9132WSullivan Michael D · Braddyville, IABuilt 1966 · S/N 28-10750 N91338Kejair LLC · San Francisco, CABuilt 1985 · S/N 28-8616008 N9133JCarter Whitney · Jackson, TNBuilt 1966 · S/N 28-3183 N9133WIngle Samuel C · Geneva, OHBuilt 1966 · S/N 28-10752 N9134JRolsing Steve Patrick · Saint Peters, MOBuilt 1966 · S/N 28-3185 N9134KDomerese Robert V · Fenton, MIBuilt 1976 · S/N 32R-7680191 N9134WGeary Michael F · Tucson, AZBuilt 1966 · S/N 28-10753 N9134YParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616010 N9135JSwaz Aviation LLC · Mesa, AZS/N 28-3186 N9136WNotty Woman Holdings LLC · Salado, TXBuilt 1966 · S/N 28-10755 N9137EAltitude Holdings LLC · Springfield, MOBuilt 1988 · S/N 3213010 N9137JYuma Piper Fliers · Yuma, AZBuilt 1966 · S/N 28-3190 N9137ZBreza Thomas S · Laud By Sea, FLBuilt 1988 · S/N 3206042 N9139WAmestoy Flyers LLC · Spokane, WABuilt 1966 · S/N 28-10759 N913CBecker Claus · West Palm Beach, FLBuilt 1975 · S/N 32-7640030 N913FLL B Rocket Corp · Attleboro, MABuilt 1969 · S/N 28R-35128 N913MSCukovic Naim · Portsmouth, NHBuilt 1976 · S/N 28-7715094 N913TCPropwash LLC · Sunnyvale, CABuilt 2000 · S/N 3257157 N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011 N9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194 N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195 N9141WSlater Daniel R · Springfield, OHBuilt 1966 · S/N 28-10762 N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196 N9142KSwales Michael K · Harrisville, MIBuilt 1976 · S/N 28-7615177 N9142WArtman Holdings LLC · Safford, AZBuilt 1966 · S/N 28-10763 N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197 N9143WLara Anthony Michael Thomas · Manitou Springs, COBuilt 1966 · S/N 28-10764 N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029 N9144WMedema Roger E · Lake Forest, ILBuilt 1966 · S/N 28-10765 N9145JBonertz Brian J · Muscatine, IAS/N 28-3200 N9145MValenzuela Anthony R · Glendale, AZBuilt 1985 · S/N 28R-8531014 N9145NKelly Howard Vincent · Chicago, ILBuilt 1988 · S/N 2831038 N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201 N9146KBartlett Jesse Charles · Henderson, NVBuilt 1976 · S/N 28-7615178 N9146WGam Aviation LLC · Sioux Falls, SDBuilt 1966 · S/N 28-10768 N9147WBishop Samuel E · Soquel, CABuilt 1966 · S/N 28-10770 N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203 N9148XFaik Salaheddine · Marion, IABuilt 1988 · S/N 2811019 N9149JJones Lynn · Birmingham, ALS/N 28-3204 N9149WTcherneshoff Robert · Clayton, NMBuilt 1966 · S/N 28-10775 N914AMWilliamson Tom P · Nacogdoches, TXBuilt 1988 · S/N 2811020 N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646 N914LALindbergh Aviation Inc · Hampton, NHBuilt 1981 · S/N 32R8129108 N914MGHolman Larry E · Cleveland, GABuilt 1970 · S/N 32-1281 N914PLand-O-Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1983 · S/N 28-8311015

Back to AD 87-08-08 R3