Registered aircraft · 85,612

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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  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:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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.

N2574RChauvin Junius · Franklin, LAS/N 18258274 N2574XBuckman Warren E III · Pennsburg, PABuilt 1985 · S/N 28-8516047 N2574Y9th Moon Enterprises LLC · Alpine, TXS/N 17249874 N2575DBurgess William S · Anchorage, AKBuilt 1952 · S/N 20727 N2575GAltes Matt · Mount Shasta, CABuilt 1959 · S/N 51875 N2575KSchlick David L · Poulsbo, WABuilt 1978 · S/N 18052997 N2575UCavu Aircraft LLC · Salisbury, NCBuilt 1979 · S/N 28-8016042 N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075 N2575YSky Unlimited · Portland, ORBuilt 1962 · S/N 17249875 N2576CFlying R LLC · Fruitdale, SDBuilt 1954 · S/N 26220 N2576DMarshall Jerry J · Parker, AZBuilt 1952 · S/N 20728 N2576LRiggin Flight Service Inc · Madison, SDS/N 17255776 N2576MEsposito Joseph Salvatore · Jacksonville, FLBuilt 1977 · S/N 28R-7803133 N2576QHamilton Steve · Carson City, NVBuilt 1966 · S/N 18257776 N2576WKepler Anthony · Newberg, ORS/N 935 N2576XOchoa Chase E · Williamsburg, VABuilt 1985 · S/N 32R-8513013 N2576YRowe John W · Glen Haven, COBuilt 1962 · S/N 17249876 N2577LKim L Jensen · Enoch, UTBuilt 1967 · S/N 17255777 N2577QSlingsby J Geoffrey · Rapid City, SDBuilt 1977 · S/N 18503520 N2577RSchomaker Michael J · Pleasanton, CABuilt 1967 · S/N 18258277 N2577WSiegel Theodore Matthew · Merritt Island, FLBuilt 1965 · S/N 3275 N2577ZMaynard Christopher J · Anchorage, AKBuilt 1964 · S/N 185-0577 N2578CPayne Megan T · Anchorage, AKFirst renewal noticeBuilt 1954 · S/N 26222 N2578DKnuths Kristian Jacob · North Pole, AKBuilt 1952 · S/N 20730 N2578UBond Air Cargo LLC · Doral, FLS/N 34-7970453 N2578WCain Mitchell J · Ellisville, MOBuilt 1965 · S/N 3276 N2578YBush James W · Skaneateles, NYBuilt 1962 · S/N 17249878 N25798Hayek Investments LLC · Gulf Breeze, FLBuilt 1986 · S/N E-2308 N2579GMcglachlin Brandon E · Moundridge, KSBuilt 1959 · S/N 51879 N2579KSkywagon LLC · Sterling, AKBuilt 1978 · S/N 18053000 N2579UHann Aviation LLC · Yuma, AZBuilt 1963 · S/N 17250179 N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071 N257CTLane Community College · Eugene, ORBuilt 1978 · S/N 287816053 N257DLN T M A Holdings LLC · Lewes, DEBuilt 1975 · S/N 32-7540141 N257FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020057 N257FK257fk LLC · Marathon, FLBuilt 1977 · S/N 17269126 N257JDAntonini Vittorio · New York, NYBuilt 1970 · S/N 310Q-0071 N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090 N257KWPridgen Aaron Wade · Pebble Beach, CAS/N 25-1205 N257LMSsb Aviation LLC · Wasilla, AKBuilt 1975 · S/N 18052548 N257MWillis Charles A · Arlington, TXBuilt 1958 · S/N D-5604 N257MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881450 N257RRegistered aircraftBuilt 1957 · S/N 34411 N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240 N257SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 32-40755 N257SHDodson International Parts Inc · Rantoul, KSS/N 31-8052121 N257TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881857 N257ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881612 N2580DPlace Ashley K · Bradenton, FLBuilt 1952 · S/N 20732 N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880

Back to AD 98-21-21 R1