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.

N24WPXv Aviation LLC · Brown City, MIBuilt 1977 · S/N 32R7780482 N2500UFrisbie Anthony G · Dallas, TXBuilt 1964 · S/N 28-1873 N2501RNelson Curtis J · Altoona, IABuilt 1969 · S/N 28-5637 N25030Eller Walton G III · Katy, TXBuilt 1985 · S/N 28-8590081 N25055Dakota N25055 LLC · Irvine, CABuilt 1985 · S/N 28-8511018 N2505RTcheutchua Romeo J · Olathe, KSBuilt 1969 · S/N 28-5638 N2507QGift Arthur D Trustee · Wanatah, INBuilt 1977 · S/N 32-7740050 N2509RStovall Shane R · Salado, TXBuilt 1969 · S/N 28-5639 N250FMParagon Airplane Leasng Co · Fort Myers, FLBuilt 2022 · S/N 28020100 N250HCCornerstone Air Holdings LLC · Fort Scott, KSBuilt 1977 · S/N 32R-7880037 N250WAWelch Eric · Lakeland, TNBuilt 1978 · S/N 32-7840102 N250WFGita Aviation LLC · Dallas, TXBuilt 1978 · S/N 28-7916088 N2510Q901 Aviation LLC · Oxford, MSS/N 32R-7780249 N2510XRegistration Pending · West Hartford, CTRegistration pendingBuilt 1985 · S/N 32-8606001 N2515USummit Professional Business Services LLC · Grand Haven, MIBuilt 1979 · S/N 28-8016026 N2515YNationwide Aviation LLC · Weatherford, TXBuilt 1985 · S/N 28-8516074 N2517QPnw Tin Goose LLC · Liberty Lake, WAS/N 32R-7780250 N2517RWaterfront Developers Inc · Hickory, NCBuilt 1969 · S/N 28-5640 N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027 N2519MCoutcher Michael A · Belleview, FLBuilt 1977 · S/N 28R-7803131 N251BCBearce Larry J · Solon, IAS/N 28R-7803174 N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N2521RSok Gregory J · Wallingford, CTBuilt 1969 · S/N 28-5641 N2521UN2521u LLC · Danbury, CTBuilt 1979 · S/N 28-8016029 N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030 N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031 N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180 N2525YWilde Stephen · Elverta, CABuilt 1985 · S/N 28-8516075 N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050 N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051 N252DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010033 N252ECClear Sky Ag Services LLC · Arapahoe, COBuilt 1969 · S/N 28-25277 N252GBrewster King Smith Jr · Gilbert, AZBuilt 1969 · S/N 28-26191 N252MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881444 N252RWatkins John Jr · Summerfield, NCBuilt 1977 · S/N 32R-7780175 N2530MHoward Robert Thomas · Palmdale, CABuilt 1977 · S/N 28R-7803132 N2531RMaierhoffer Henry F Jr · Sylvania, GAS/N 28-5642 N2531YPremier Aviation LLC · Sioux Falls, SDBuilt 1985 · S/N 28-8590083 N2533XFmfa Inc · Wilmington, DES/N 28-8590086 N2535UMyer Mark A · Sandusky, OHBuilt 1979 · S/N 28-8090054 N25386Fairview Farms Inc · Poteau, OKBuilt 1985 · S/N 28-8590088 N253DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010034 N253JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020034 N253MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881445 N253SWBatts David · Lyons, COBuilt 1965 · S/N 28-2328 N253WMLambert Timothy Allen Jr · Burleson, TXBuilt 1964 · S/N 28-2026

Back to AD 87-08-08 R3