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.

N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423 N246AZRegistered aircraftBuilt 1983 · S/N 28-8311025 N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002 N246JBN246jb LLC · Boynton Beach, FLBuilt 1973 · S/N 28R-7435003 N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056 N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049 N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073 N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074 N2476MPremier Flight Center LLC · Hartford, CTBuilt 1977 · S/N 28-7816286 N2477SAverett University · Danville, VABuilt 2012 · S/N 2843700 N2477T7 Shooter Ranch LLC · Aledo, TXBuilt 1971 · S/N 28-7205055 N2478T5b Aviation LLC · Duncan, OKBuilt 1971 · S/N 28-7205059 N2478VKozura Ronald J · Pine Grove, PABuilt 1985 · S/N 28-8516057 N247GWRotondo Joseph N · Baden, PABuilt 1980 · S/N 32-8106008 N247MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881710 N247MMSale Reported · Park City, UTSale reportedS/N 28-7310132 N2480VLyons Emily A · Homewood, ALBuilt 1985 · S/N 28-8590075 N2481TWidell Randall Ross · Wilsonville, ORBuilt 1971 · S/N 28-7205058 N2485RGriffith Kyle R · Talihina, OKBuilt 1969 · S/N 28-5633 N2485XLostetter Evan · Bakersfield, CABuilt 1985 · S/N 28-8516069 N2488MMeads Rodney L · Camden, NCBuilt 1977 · S/N 28-7816289 N2488PPs Engineering Inc · Lenoir City, TNBuilt 1999 · S/N 2843282 N248AMDesfosse Donald J Trustee · Andover, MABuilt 1996 · S/N 3246054 N248BFotheringham Jack · Palmer, AKS/N 28-7505135 N248BNEshleman James E · Yucaipa, CAS/N 28R-7703126 N248CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881003 N248MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881711 N2490MDmld Corp · Wilmington, DEBuilt 1977 · S/N 28-7890254 N2490YSheboygan Flight Plane III LLC · Sheboygan, WIBuilt 1985 · S/N 28-8590077 N2491TLichtman Bruce A · Stafford, VABuilt 1971 · S/N 28-7225078 N2492TOmni Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7205060 N2494MJbbs Enterprises Inc · Middletown, DEBuilt 1977 · S/N 28-7890255 N2495MPark Brian D · Springville, UTBuilt 1977 · S/N 28R-7837090 N2495TAvia Flight Academy LLC · Stratford, CTBuilt 1971 · S/N 28-7205061 N2496MMorgan Jay · Fort Mill, SCBuilt 1977 · S/N 28R-7837091 N2497RMarkley John T · Center Harbor, NHBuilt 1969 · S/N 28-5636 N2499QLand Phillip R · Hartford, WIBuilt 1977 · S/N 28-7725197 N249CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881636 N249JAEagle Aviation LLC · Indianapolis, INBuilt 2021 · S/N 28020028 N249MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881712 N249NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842059 N249WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1976 · S/N 28-7690114 N24APMartinelli John P · Cumberland, RIBuilt 1973 · S/N 28-7305199 N24FLHill Steven D · Carroll, IABuilt 1964 · S/N 28-1790 N24JSSpillman Joe H · Marble Falls, TXBuilt 1967 · S/N 28-3851 N24MTPapa Romeo India LLC · Knoxville, TNS/N 32R-7780523 N24NAForcey Marcia L · Westville, INBuilt 1967 · S/N 28-4018 N24SWDann Mark A · Utica, OHBuilt 1975 · S/N 28R-7535213 N24TSAirquest Aviation Lp · Butler, PABuilt 1979 · S/N 28-7916462 N24VRHarris Daniel P · Auburn, ALBuilt 1981 · S/N 32R-8229006

Back to AD 87-08-08 R3