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.

N2265QMyl High Flying Club LLC · Mccall, IDS/N 32-7740048 N2266MGraves Robert E · Danville, INBuilt 1977 · S/N 28R-7837075 N2266QJudkins James C · Alpharetta, GABuilt 1977 · S/N 32R-7780237 N2266ZLobdell Robert T · Franklinville, NJBuilt 1979 · S/N 28-8090052 N2269MSpencer Donald I Jr · Knoxville, TNBuilt 1977 · S/N 32R-7880060 N2269QN2269q LLC · West Palm Beach, FLS/N 28-7725189 N226BVKimberlin G Tyler · Fairbury, NEBuilt 1976 · S/N 32R-7680225 N226DFMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881535 N226DTAlpha Tango LLC · Glenn Dale, MDBuilt 1995 · S/N 3246006 N226LLLavezoli John Jr · Canonsburg, PABuilt 1977 · S/N 28-7716221 N226SPHaaf Thomas P · Woodstown, NJBuilt 1978 · S/N 28-7990225 N226STMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881570 N226ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881609 N2272MGriff Air Ltd · Elk Grove, ILBuilt 1977 · S/N 28-7816269 N2272QLane Community College · Eugene, ORS/N 28-7716094 N2272TNedley Nathan D · Georgetown, KYBuilt 1972 · S/N 28R-7235001 N2273FCascade Aviation LLC · Burlington, WABuilt 1969 · S/N 28-25431 N2273TDevenezia Robert P · Brentwood, TNBuilt 1971 · S/N 28R-7135175 N2274QMaines Barry K · Longview, TXS/N 28-7790390 N2274THoller James F · Stuart, FLBuilt 1971 · S/N 28R-7135176 N22760Tuskegee Airmen National Historical Museum · Detroit, MIS/N 28-7425211 N22763Horstick Thomas E · Garnett, KSS/N 28-7425213 N2276MMuddy River Capital LLC · Glendive, MTBuilt 1977 · S/N 28R-7803119 N2277DTaking Flight LLC · Saint Augustine, FLBuilt 1974 · S/N 28-7425225 N2277QComanche Aviation LLC · Chanute, KSBuilt 1977 · S/N 28R-7703060 N2277VN2277v LLC · Mesa, AZBuilt 1975 · S/N 28-7525188 N2279TRegistration Pending · Lakeville, MNRegistration pendingBuilt 1971 · S/N 28R-7135181 N227EMVisceral Technologies LLC · Yulee, FLBuilt 2001 · S/N 3257208 N227JKMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881537 N227PQMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881544 N227RFHouser Harry David Jr · Williamstown, WVBuilt 1972 · S/N 327200045 N227XYMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881571 N2280QJaz One Holdings Inc · Farmingdale, NYS/N 28-7716095 N2281QFreeman Michael J · Chillicothe, OHBuilt 1977 · S/N 28-7716096 N2283QPearl Aviation Inc · Appleton, WIS/N 28-7790391 N2284QZm Farms Lllp · Horace, NDS/N 28-7790392 N2285QGandy John W III · Mount Vernon, TXBuilt 1977 · S/N 28R-7737032 N2286MRegan Herbert George · Gowen, MIBuilt 1977 · S/N 28-7816271 N2286QRinker John W · Pontiac, ILBuilt 1977 · S/N 28R-7703062 N2288QMidnight 30 LLC · Columbia, MSBuilt 1977 · S/N 32R-7780242 N2288ZMaxwell Robert H Jr · Quincy, FLS/N 28-2196 N2289MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7816274 N228AMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 28-7990544 N228GGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 28-7990387 N228JSLipsett Andrew William · Wilmington, DEBuilt 1974 · S/N 28-7415103 N228KHSkyceci LLC · Comelius, NCBuilt 2022 · S/N 2881521 N228MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881985 N228NCIal Corp · Lewes, DEBuilt 1969 · S/N 28R-35652 N228QRMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881538 N228TXTexas State Technical College · Waco, TXFirst renewal noticeBuilt 2007 · S/N 2844136

Back to AD 87-08-08 R3