Registered aircraft · 22,413

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.

N6077WParrish Stephen W · Minneola, FLBuilt 1964 · S/N 28-20090 N6078FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020152 N6079WAmos Warren E · Cypress, TXBuilt 1964 · S/N 28-20092 N607EABlue Horizons Flying Club Inc · Perrysburg, OHBuilt 1980 · S/N 28-8116140 N607FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916271 N607JWMid-South Bulk Services Inc · West Memphis, ARBuilt 1976 · S/N 32R-7680137 N607KWWalsh Kevin T · Morristown, NJBuilt 1976 · S/N 32R-7680390 N607NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881185 N607PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841215 N6080HShealy Horace L Jr · Chesapeake, VAS/N 28-7890207 N6081HFlathers George William II · Palmyra, VABuilt 1977 · S/N 28-7890208 N6083HAerotyne Aviation LLC · Omaha, NEBuilt 1977 · S/N 28R-7837052 N6085FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020153 N6086WPegasus Ir LLC · Miami, FLBuilt 1964 · S/N 28-20100 N6089FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020154 N6089HGromer Gerald M · Sebastopol, CABuilt 1977 · S/N 28R-7803088 N608ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843758 N608FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020208 N608FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916328 N608GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881194 N608LESimons Barry · Inverness, FLS/N 28-7911298 N608PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841217 N608TMMarijono Vendy · Charlotte, NCBuilt 1981 · S/N 32-8206004 N6090FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020155 N6091FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020156 N6091WN6091w LLC · Orange Park, FLS/N 28-20105 N6092WBoling Bret J · Wichita, KSS/N 28-20106 N6093HAmerican Butchers LLC · Dallas, TXS/N 32R-7880044 N6093WLee Richard L · Bowie, TXBuilt 1964 · S/N 28-20107 N6095SAri Ben Aviator Inc · Fort Pierce, FLBuilt 2007 · S/N 2843662 N6096ZYoung Collin H · Spring, TXBuilt 2010 · S/N 2843678 N6097FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020157 N6097WWallette Robert Michael · Port Saint Lucie, FLBuilt 1964 · S/N 28-20111 N6098FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020158 N6098WFall Line Aviation LLC · Augusta, GAS/N 28-20112 N609DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881982 N609FAStratus Air LLC · New Castle, DEBuilt 2025 · S/N 28020209 N609FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716270 N609NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881285 N609SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881599 N60LYLeon Roberts Enterprises LLC · Vienna, VABuilt 1965 · S/N 32-10 N60NAHampden Aviation Services Inc · Northampton, MABuilt 1980 · S/N 28-8116049 N60PLPapa Lima LLC · York, NEBuilt 1967 · S/N 32-870 N60SULuther Frank E · Amanda, OHBuilt 2005 · S/N 2844121 N60TTOurhappyfamilyplane LLC · Mason, OHBuilt 1979 · S/N 32-7940151 N60UMWbyaa LLC · Saline, MIBuilt 1969 · S/N 28-11347 N6100JFranklin County Flying Club Inc · Turners Falls, MABuilt 1976 · S/N 28-7615302 N61011Inter American University Of Puerto Rico · Bayamon, PRBuilt 2008 · S/N 2844139 N6101WStuder Joseph D · Troy, KSBuilt 1964 · S/N 28-20115 N6103JLance Shane · Cedaredge, COBuilt 1976 · S/N 28-7610121

Back to AD 87-08-08 R3