Skip to content

Registered aircraft · 22,430

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.

N16485Elemental Process Solutions LLC · Troy, ILBuilt 1973 · S/N 28-7305265 N16487Piper Cherokee LLC · Seal Beach, CABuilt 1973 · S/N 32-7340090 N16488Kuemmerle Steven C · Grayslake, ILBuilt 1973 · S/N 28-7305266 N1648HWcc Eco LLC · Arvada, COS/N 28-7790322 N1648JMilan Air Service Inc · Milan, MIS/N 28-24041 N16490Schlott James W · East Falmount, MABuilt 1973 · S/N 28-7325284 N16492Fields Franc C · Jessup, MDBuilt 1973 · S/N 28-7305268 N16496Gesler Mark A DBA · Lima, OHBuilt 1973 · S/N 28-7305270 N16497Brennan Daniel C · Powell, WYBuilt 1973 · S/N 28-7310101 N16498Owens Hay LLC · Crane, ORBuilt 1973 · S/N 32-7340091 N1649JRegistration Pending · Bozeman, MTRegistration pendingBuilt 1967 · S/N 28-24042 N164AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010060 N164DPAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 28-8016190 N164ERSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2841180 N164GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881457 N164JAgster Robert J · Fstrvl Trvose, PABuilt 1980 · S/N 32R-8029071 N164LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010063 N164LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-714 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 N164ULariviere Jeffrey A · Douglassville, PABuilt 1967 · S/N 32-996 N16509Greensburg Jeannette Airport Administration · Jeannette, PABuilt 1973 · S/N 28-7305271 N1650JQureini Khalil H Vii · Kansas City, MOBuilt 1967 · S/N 28-24043 N16513Ashworth Diane A Executor · Chase City, VABuilt 1973 · S/N 28-7305273 N16518Dokter Garret H Jr Trustee · Big Bear Lake, CABuilt 1973 · S/N 28-7310102 N16526Wesley Joseph L · Pismo Beach, CABuilt 1973 · S/N 28-7325291 N16527Skolnick Sanford M · Novato, CABuilt 1973 · S/N 28-7305274 N1652HDemelva Aviation LLC · Alexandria, VAS/N 32R-7780168 N1652NAllison Christopher · Cartersville, GABuilt 1999 · S/N 3257119 N16530Beldon Concrete LLC · Liberty, KYBuilt 1973 · S/N 28R-7335158 N16531Bethge Wade K · Paxinos, PABuilt 1973 · S/N 28R-7335159 N16534Wahler Edward William III · Asheville, NCBuilt 1973 · S/N 28-7325292 N16535Wdc Enterprises LLC · Beaumont, TXBuilt 1973 · S/N 28-7325293 N16537Lesmeister Dillon J · Chadron, NEBuilt 1973 · S/N 28-7305277 N1653JSale Reported · Bloomburg, TXSale reportedBuilt 1967 · S/N 28-24047 N16542Marianas Air Transfer Inc · Saipan, MPS/N 32-7340093 N16547Mickle Charles R · Hinton, OKS/N 28-7325297 N16548Watchman Aviation LLC · Pierceton, INBuilt 1973 · S/N 28-7305280 N1654JStygar Richard M · Coal City, ILBuilt 1967 · S/N 28-24049 N16551Mike Smith Construction Inc · Holyoke, COBuilt 1973 · S/N 28-7305283 N16554Sk Group LLC · Moore, SCBuilt 1973 · S/N 28R-7335162 N16555Vampola Timothy D · Bellevue, NEBuilt 1973 · S/N 28R-7335163 N16556Sale Reported · Fargo, NDSale reported, pending cancellationBuilt 1973 · S/N 28-7310105 N1655JGallant Arthur · Kingston, NHBuilt 1967 · S/N 28-24051 N16560Wasson Tom L · Lakeport, CABuilt 1973 · S/N 28-7325298 N16564Bradley Jason · Fort Mohave, AZBuilt 1973 · S/N 28-7305285 N16566Schaumberg John · Lebanon, INS/N 28R-7335164 N16583Gawlikowski Joseph J · Spearfish, SDBuilt 1973 · S/N 28-7325301 N1659JHanger C22 LLC · Hillsboro, ORBuilt 1968 · S/N 28-24056 N165AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010059 N165FTParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216195

Back to AD 87-08-08 R3