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.

N82456Ajk Aircraft LLC · Xenia, OHBuilt 1980 · S/N 32-8006080 N82457Cassella Matthew Victor · Branford, CTBuilt 1980 · S/N 32-8006081 N8245CVector Aviation LLC · Mentor, OHBuilt 1980 · S/N 28-8090372 N8245NShimei Mark A · Titusville, FLBuilt 1969 · S/N 28-25454 N8245WJ & L Aircraft Rentals Llctrust · Oxford, GABuilt 1965 · S/N 28-2391 N8245YViboonvutiwong Panupan · Eastvale, CABuilt 1980 · S/N 28R-8031152 N8246EDubois Aviation Inc · Chino, CABuilt 1982 · S/N 28-8216189 N8246NMorgan Jeffrey P · Mc Veytown, PABuilt 1969 · S/N 28-25455 N82470Tfto LLC · Franklin, TNBuilt 1984 · S/N 32R-8429016 N8247CPonder Harvey E · Knoxville, ILBuilt 1982 · S/N 28-8290158 N8247MChamberlain Richard Sr · Lafayette, LABuilt 1980 · S/N 28R-8031153 N8247NHorizon Edge LLC · Helena, MTBuilt 1969 · S/N 28-25456 N8247TSaratoga Skies LLC · Wilmington, DEBuilt 1982 · S/N 32R-8213056 N8247VVeldhuizen Chris J · Edgerton, MNBuilt 1980 · S/N 28-8011136 N8247WDombrowski Gregory John · Mangum, OKBuilt 1965 · S/N 28-2394 N8247YPiper Aircraft Inc · Vero Beach, FLBuilt 1980 · S/N 32-8006092 N82487Woodruff Thomas C · Pacific Grove, CABuilt 1980 · S/N 28-8116007 N8248DKillam Michael R · Honesdale, PABuilt 1980 · S/N 32R-8013121 N8248NGarcia Leobardo · Tucson, AZBuilt 1969 · S/N 28-25457 N8248QElkhart Flying Club Inc · Nappanee, INBuilt 1982 · S/N 32R-8329004 N8248TJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8116003 N8249BEscobar Alfredo · Canyon Country, CAS/N 28-8116008 N8249LErickson Anesthesiology · Newburgh, INBuilt 1980 · S/N 28R-8031154 N8249NAero Club Aviation LLC · Apollo Beach, FLBuilt 1969 · S/N 28-25459 N8249WHartpence Damian K · Newcastle, OKBuilt 1965 · S/N 28-2397 N824BBBig Bend Community College · Moses Lake, WABuilt 2023 · S/N 2881695 N824DBPurple Piper Airways LLC · Indian Rocks Beach, FLBuilt 2002 · S/N 3246209 N824DXElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 28-7990061 N824NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881291 N824PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881336 N824VRDodson International Parts Inc · Rantoul, KSBuilt 1996 · S/N 2843058 N824WBest Start Inc · Kingman, AZBuilt 1982 · S/N 32R8229032 N8250NBruce James E · Greenfield, INS/N 28-25460 N8250VCorea Darren T · Galveston, TXBuilt 1980 · S/N 28R-8018099 N8250WMorehead Leonard E · Bryan, TXS/N 28-2399 N8251EMalibu Aviation LLC · Elkhorn, WIBuilt 1980 · S/N 28R-8031156 N8251NLarue Jesse W · College Station, TXBuilt 1969 · S/N 28-25461 N8251SAirlife Aviation LLC · Elkridge, MDS/N 28-8316081 N8251VMarine Service Of Guntersville Inc · Guntersville, ALBuilt 1980 · S/N 32-8006094 N8251WKeddis Moheb N · Fairfax, VABuilt 1965 · S/N 28-2401 N82525Bravo Zulu Aero LLC · Claremont, CABuilt 1982 · S/N 28R-8231068 N8252DKennedy Carl J Jr Trustee · Gardnerville, NVBuilt 1982 · S/N 28R-8331011 N8252EMiami Flight Training LLC · Miami, FLBuilt 1980 · S/N 28-8016373 N8252NWhiting Reed Brandon · Mesa, AZBuilt 1969 · S/N 28-25462 N8252ZHodges Albert H Executor · Lyons, GAS/N 28-8116011 N82532Smithy Grain Inc · Presho, SDBuilt 1980 · S/N 32-8024039 N8253AArcher N8253a LLC · Orange, CTBuilt 1980 · S/N 28-8190013 N82542Registered aircraftS/N 32R-8213059 N8254BJimenez Carlos · Coronado, CAS/N 32-8024042 N8254FStewart Rodney W · Pensacola, FLBuilt 1977 · S/N 28-7715258

Back to AD 87-08-08 R3