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.

N8393RFisher B Barton · Bowman, NDBuilt 1966 · S/N 28-22270 N8393XAeroforge LLC · Crystal Lake, ILBuilt 1981 · S/N 32R-8129074 N83947Iziair LLC · Mclean, VAFirst renewal noticeBuilt 1981 · S/N 28-8190247 N8394CThree Rivers Aero LLC · Three Rivers, MIBuilt 1976 · S/N 28-7690132 N8394DTrident Aircraft Inc · Easton, MDBuilt 1981 · S/N 28-8116238 N8394WLockhart Flying Club · Lockhart, TXBuilt 1965 · S/N 28-2602 N8394YGadamic LLC · Fresno, CABuilt 1981 · S/N 28-8190246 N83956Mc Laughlin Paul E · Mansfield, OHBuilt 1981 · S/N 28R-8131142 N8395APrecision Drilling Services LLC · Honolulu, HIBuilt 1981 · S/N 28-8190248 N8395CN8395c LLC · Peachtree City, GABuilt 1976 · S/N 28-7690133 N8395HApple X05 LLC · Spring Hill, FLBuilt 1981 · S/N 28-8190249 N8395RRegistration Pending · Dover, DERegistration pendingBuilt 1966 · S/N 28-22272 N8395SWall Gerardo · Seminole, TXS/N 28-8111075 N8395YMacair Aviation LLC · Xenia, OHBuilt 1981 · S/N 28R-8118072 N83960Paris Air Inc · Vero Beach, FLBuilt 1981 · S/N 28-8116244 N8396JCurtsinger Joseph C Jr · Nolensville, TNBuilt 1981 · S/N 32R-8129075 N8396LEmerald Coast Aircraft LLC · Panama City Beach, FLBuilt 1981 · S/N 28-8190288 N8396RPatton Graham S · Chattanooga, TNBuilt 1966 · S/N 28-22273 N8396WCarpenter Kenneth G · Dripping Springs, TXS/N 28-2606 N8396ZSaflite Pilot Training Inc · Hooksett, NHS/N 28-8116243 N83974Otoole Airways LLC · Great Neck, NYBuilt 1981 · S/N 28-8190254 N8397CParker Edward M Jr DBA · Griffin, GABuilt 1976 · S/N 28R-7635156 N8397LWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8190252 N8397RMiller Dean R · Edmond, OKBuilt 1966 · S/N 28-22274 N83988Frese Dental LLC · Birmingham, ALBuilt 1981 · S/N 32R-8113080 N8398HAircom Mechanical · Milpitas, CABuilt 1981 · S/N 28R-8131144 N8398JBryant Thomas H · Justin, TXBuilt 1981 · S/N 32-8106073 N8398RParker Jeffrey S · Aurora, OHBuilt 1966 · S/N 28-22275 N8398WFlaspohler David E Trustee · Lake Lotawana, MOBuilt 1965 · S/N 28-2608 N83993Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8216007 N839ALHorizon Dreams LLC · Homer, GABuilt 2000 · S/N 2843412 N839DXPiper Aircraft Inc · Vero Beach, FLBuilt 2024 · S/N 2881825 N839JCGng LLC · New Market, ALBuilt 1973 · S/N 28R-7335193 N83BETecce Andrew J · Cambridge, MDS/N 28-22218 N83EDRolando Pierluigi · San Marcos, CABuilt 1979 · S/N 28R-7931279 N83KLLagrelius Thomas W · Redondo Beach, CABuilt 1999 · S/N 3246129 N83LMJohannsen Gregory A · Salina, KSBuilt 1964 · S/N 28-1563 N83VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780226 N84001Darcy Aviation LLC · Danbury, CTBuilt 1985 · S/N 28-8516080 N84007Smith Michael W · Sharon, CTBuilt 1981 · S/N 28-8190259 N84008Harkey Wesley · Sherrills Ford, NCBuilt 1981 · S/N 28R-8131145 N8400SParks Perry A · Goodell, IAS/N 28-8116251 N84014C-140 Company LLC · Milton, FLBuilt 1981 · S/N 28-8190263 N84015Tarakji Mohamad Hani A · Van Nuys, CABuilt 1981 · S/N 28-8190264 N8401BSale Reported · Crofton, KYSale reportedBuilt 1981 · S/N 32R-8113077 N8401DDarwin D Pluid · Eureka, MTBuilt 1981 · S/N 32R-8129076 N8401FSchriner Keith D · Lanark, ILBuilt 1976 · S/N 28-7790238 N8401RLaplante David W · New Baltimore, MIBuilt 1966 · S/N 28-22278 N8401TWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8290033 N84023Sidoti Charles A · Boston, MABuilt 1981 · S/N 32R-8113081

Back to AD 87-08-08 R3