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.

N8423WGillanders Kenneth William · Carson City, NVBuilt 1965 · S/N 28-2650 N8424ATringale Alison · Port Saint Joe, FLBuilt 1981 · S/N 32R-8129092 N8424CD And A Enterprises LLC · Wilmington, DEBuilt 1976 · S/N 32-7640064 N8425FSons Aviation LLC · Moody, ALBuilt 1976 · S/N 28-7715259 N8425HJohansen Herbert J · Bennington, NEBuilt 1981 · S/N 32R-8113099 N8425PSaratoga 25 Papa LLC · Carmel, INBuilt 1981 · S/N 32R-8113101 N8425TN93lv LLC · Lancaster, PABuilt 1981 · S/N 32R-8113102 N8425WBenner James R · Goshen, INBuilt 1965 · S/N 28-2652 N84263Chadwick James B · Rch Palos Vrd, CABuilt 1981 · S/N 32R-8129094 N8426CHarper-Smith Michael · Tarzana, CABuilt 1976 · S/N 32R-7680114 N8426RBryant Bryce E · Evans City, PABuilt 1966 · S/N 28-22303 N8427CMorgan Aviation LLC · Greensboro, NCBuilt 1981 · S/N 32-8124030 N8427GWarrior II Ltd · Des Plaines, ILBuilt 1981 · S/N 28-8116297 N8427KInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116299 N8427RLopez Trinidad V · El Cajon, CAS/N 28-22305 N8427TPierce Rex G · Shorewood, ILBuilt 1981 · S/N 28-8190302 N8427WKsiezyk Donald G · Wadsworth, OHBuilt 1981 · S/N 28-8290030 N84285Paquin James R · Orangeburg, SCBuilt 1981 · S/N 28-8111095 N8428BHiggins James · Oxford, NCBuilt 1981 · S/N 28-8190304 N8428HWilson Jessica D · Gallipolis Ferry, WVBuilt 1981 · S/N 28-8190305 N8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1981 · S/N 28-8190307 N8428WAces High Aviation LLC · Casper, WYBuilt 1965 · S/N 28-2656 N8429APhoenix Flying Club Inc · Odenton, MDBuilt 1981 · S/N 28-8111096 N8429NSeybert Daniel P · Anchorage, AKBuilt 1981 · S/N 32-8106089 N8429WCleveland Tommy E · Mountain View, ARBuilt 1965 · S/N 28-2659 N8429XLinville Manor LLC · Reidsville, NCBuilt 1981 · S/N 32R-8113105 N842BJMaster Trade LLC · Detroit, MIBuilt 1977 · S/N 28-7716252 N842MM43 Northstar LLC · Dodgeville, WIBuilt 1984 · S/N 28-8411019 N842TSAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1997 · S/N 28R-7703180 N842TTMartsolf Kenneth W · Gresham, ORBuilt 1966 · S/N 28-22350 N8430BTrident Aviation LLC · Bedford, NHBuilt 1981 · S/N 32R-8129097 N8430RRegistration Pending · Calera, OKRegistration pendingBuilt 1966 · S/N 28-22309 N8430WZuber Thomas P · Opelika, ALBuilt 1965 · S/N 28-2660 N8431WAhearn Bernard Francis · Farmington, NHS/N 28-2661 N84326Yang Edward E · Killeen, TXBuilt 1981 · S/N 28-8116313 N8432BClaxton David R · Cookeville, TNBuilt 1981 · S/N 32R-8113112 N8432CEmpire Aviation · Oxford, NCBuilt 1976 · S/N 28-7625117 N8432WBinek Darwin P · Midlothian, TXBuilt 1965 · S/N 28-2662 N84337Kent East Inc · Wilmington, DES/N 32R-8129104 N8433AWoods Todd Ryan · Perry, OKBuilt 1981 · S/N 32-8124032 N8433NBrickhaus David J · Weldon Spring, MOBuilt 1981 · S/N 32-8106095 N8433RRichards Riley · Seattle, WABuilt 1966 · S/N 28-22313 N8433WKilduff James L · Wellsboro, PABuilt 1965 · S/N 28-2663 N8433YLomeli Rigoberto Orozco Jr · Longs, SCBuilt 1981 · S/N 32R-8129101 N8434RPeoples John R Jr · Hixson, TNS/N 28-22314 N8434WAlpha-One Air Service LLC · Concord, NCBuilt 1965 · S/N 28-2664 N84350Piecko Michael T · Genoa, ILBuilt 1981 · S/N 28-8290006 N8435DOrbis Advisory Services LLC · Hebron, KYBuilt 1981 · S/N 28-8290001 N8435FRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1981 · S/N 28-8290002 N8435G303 LLC · Beaumont, TXBuilt 1981 · S/N 28-8290003

Back to AD 87-08-08 R3