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.

N23DDK Tahoe Air LLC · Glendale, CABuilt 2023 · S/N 2881676 N23JTWhitman Michael V · Guys Mills, PABuilt 1972 · S/N 28-7325192 N23LAWill Voyles Farms LLC · Wynne, ARS/N 32-7840045 N23LEMidstate Aviation 1 LLC · Owosso, MIBuilt 1981 · S/N 28R-8231021 N23MCFilm Fliers Inc · Orlando, FLBuilt 1976 · S/N 32R-7680190 N23MMAmerica Atlantic Aviation Inc · Stuart, FLBuilt 1967 · S/N 32-40367 N23NANorthampton Aeronautics Inc · Northampton, MABuilt 1977 · S/N 28-7716036 N23NVAvk Air LLC · Harvest, ALBuilt 1977 · S/N 32R7780373 N23RWTirpak Garrett J · Daphne, ALBuilt 1977 · S/N 32R-7780535 N2400Ticknor Rodney J · Bridgewater, IABuilt 1967 · S/N 28-4586 N240AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881731 N240JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020010 N240MKFly254 LLC · Waco, TXS/N 28-26527 N240UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020161 N2411MAltshuler David · Cambridge, MAS/N 28R-7803126 N2412MChristensen Broadcast Group Inc · Watertown, SDBuilt 1977 · S/N 28R-7803127 N2412RGagnon David D · New Market, ALS/N 28-5615 N24139Averett University · Danville, VABuilt 2011 · S/N 2843697 N2413TRing Michael E · Lake Village, INBuilt 1971 · S/N 28-7205053 N2414QErhart Jeffery R · Zephyr Cove, NVS/N 32R-7780246 N2416MSun South Aviation LLC · Wilmington, DEBuilt 1977 · S/N 32R-7880063 N2417MRens Troy D · Marshfield, WIBuilt 1977 · S/N 32R-7880064 N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617 N241JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020011 N241NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1999 · S/N 2842051 N241SECarrie Chad Michael · Fort Worth, TXBuilt 2006 · S/N 3246241 N241VUDynamic Aircraft Services LLC · Hurst, TXS/N 28-7515409 N241ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881610 N2421RMerryman Todd K · Shickley, NEBuilt 1969 · S/N 28-5618 N2421WJohnston John · Sheboygan, WIBuilt 2023 · S/N 2881631 N2422UDennissan LLC · Noble, OKBuilt 1979 · S/N 32R-8029002 N2422YMarker Aviation LLC · Keller, TXBuilt 1966 · S/N 28-3171 N2423RAluminum Falcons Flying Club LLC · Bloomsburg, PABuilt 1969 · S/N 28-5619 N2424FPerformance Aviation Services LLC · Belmont, OHBuilt 1964 · S/N 28-2117 N2424VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1972 · S/N 28-7225586 N2425MTap Solutions Inc · San Diego, CABuilt 1977 · S/N 28-7816283 N2427M18 Rwy LLC · Falmouth, MEBuilt 1977 · S/N 28-7816284 N2427RFalcon Flight Squadron Inc · Los Angeles, CABuilt 1969 · S/N 28-5620 N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044 N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390 N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732 N242CCRecreational Management Inc · Mount Ida, ARBuilt 1997 · S/N 3246095 N242EBEb Marine LLC · Riviera Beach, FLBuilt 1967 · S/N 32-40229 N242EX242ex LLC · West Palm Beach, FLS/N 32-7940234 N242KFTio Pedro P · Miami, FLBuilt 2002 · S/N 3257277 N242KMPlane Care Inc · Weston, FLBuilt 1977 · S/N 32-7740111 N242NDHaye Patrick W · Minot, NDBuilt 1999 · S/N 2842052 N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137 N242PHoeme Eric L · Leoti, KSBuilt 1967 · S/N 28-10998 N2430YBuckman Arnold H Trustee · Spring Valley, ILBuilt 1985 · S/N 32R-8513002

Back to AD 87-08-08 R3