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.

N2433MHarkey Aviation LLC · Sherrills Ford, NCBuilt 1977 · S/N 28-7816285 N24342Loma Aviation LLC · San Diego, CABuilt 1973 · S/N 287305419 N2434MSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1977 · S/N 28-7890251 N2435MBrolan Aviation LLC · Kansas City, MOBuilt 1977 · S/N 28-7890253 N2436MVenture Aviation Inc · Arlington, MABuilt 1977 · S/N 28R-7837089 N2436YAlpha Flight Academy · Concord, CANon-citizen corporation, flight hours not reportedBuilt 1985 · S/N 28-8516056 N24372Curns James R · New London, WIBuilt 1970 · S/N 28-5665 N2438RSpeed Hunter Aviation LLC · Franklin, OHBuilt 1969 · S/N 28-5622 N243AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881733 N243DWSijtsma Wouter · Ladson, SCS/N 2844088 N243GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881113 N243JAYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 28020019 N243MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881708 N243PSN9089 LLC · Lewes, DES/N 3257073 N243XJLoiacono Vincent · Sunfield, MIBuilt 1965 · S/N 28-2095 N2447RGift Academy Inc · Vernon, TXBuilt 1969 · S/N 28-5623 N2448MSnider Robert Douglas Daniel · French Camp, CABuilt 1977 · S/N 28R-7803130 N2448RRegistration Pending · Highland Lakes, NJRegistration pendingS/N 28-5624 N2449EWikette Mathias · West Chester, OHBuilt 1970 · S/N 28-26801 N244AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881734 N244BMCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1974 · S/N 28-7415157 N244DRG H Enterprises Inc · Baton Rouge, LABuilt 1972 · S/N 28-7305018 N244JALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 2021 · S/N 28020024 N244MADc Air LLC · Centerville, OHS/N 3246218 N244MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881709 N244NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842054 N244SDPerazzo Enterprises Inc · Brookeland, TXS/N 28-7125536 N2450UDouble D Flyboys LLC · Taylorsville, UTBuilt 1979 · S/N 28-8090046 N2451ROracle Aviation LLC · Omaha, NEBuilt 1970 · S/N 28-5754 N2453RCendejas Christian · Montclair, CABuilt 1969 · S/N 28-5626 N2454TSummit Skyhawk LLC · Pleasant Hill, ORBuilt 1971 · S/N 28-7205054 N2458QM&M Aviation LLC · South Windsor, CTS/N 28-7716102 N245AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881758 N245CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881355 N245DMEley Mitchell · Rockton, ILS/N 28-10556 N245DWJr Aircraft LLC · Dayton, OHBuilt 2003 · S/N 2844090 N245MAJc Aviation LLC · Bedminster, NJBuilt 2001 · S/N 3257215 N245QWhitaker William D · Mt Pleasant, TXBuilt 1968 · S/N 28-24382 N245TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020188 N245TPStrable Sam · Cecil, OHBuilt 1999 · S/N 2843301 N2460QHamilton Aviation Group LLC · Lula, GABuilt 1977 · S/N 28-7790398 N2460RScilex Richard D · Hixson, TNBuilt 1969 · S/N 28-5627 N2460UAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 28-8090048 N2461MAbdulla Urooj · Damon, TXBuilt 1977 · S/N 32-7840049 N2461QJessi Air Ltd · West Salem, OHBuilt 1977 · S/N 28-7790399 N2462RTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1969 · S/N 28-5628 N2464QWilson Jeff · White Bluff, TNBuilt 1977 · S/N 28R-7737035 N2464WOktela Steven L · Melbourne, FLS/N 3213093 N2465RDarrow Brett · Minerva, NYS/N 28-5629 N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074

Back to AD 87-08-08 R3