OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,620

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
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.

N201YVMay Richard B · Mammoth Lakes, CABuilt 1978 · S/N 24-0528N201ZCavu Holdings LLC · Medon, TNBuilt 1978 · S/N 24-0542N201ZBBrowne Michael T · Ada, OKBuilt 1978 · S/N 24-0415N201ZDFlight Eval LLC · Flagler Beach, FLBuilt 1978 · S/N 24-0749N201ZESoeby Paul R · Walhalla, NDBuilt 1978 · S/N 24-0638N201ZFForever Aviation LLC · Houston, TXBuilt 1978 · S/N 24-0650N201ZGHaugen Mark K · Newhall, CABuilt 1978 · S/N 24-0640N201ZHBailey Michael D · Dover, FLS/N 24-0535N201ZLDressler David C · Mission Viejo, CABuilt 1978 · S/N 24-0536N201ZNJp Martin Service LLC · Hialeah, FLBuilt 1978 · S/N 24-0537N201ZQReber William T · Terrace Park, OHBuilt 1978 · S/N 24-0539N201ZRYost Robert L · Bridgeport, WVBuilt 1978 · S/N 24-0540N201ZTHn Journey LLC · Lewes, DEBuilt 1978 · S/N 24-0543N201ZVLeung Michael H · Millstone Township, NJBuilt 1978 · S/N 24-0546N201ZWHoward Richard A · Venice, FLBuilt 1981 · S/N 24-1194N201ZYFlight Associates Inc · Malabar, FLS/N 24-0551N201ZZSky West Aviation Inc Trustee · Albuquerque, NMS/N 24-0745N20201Castillo Frank E · San Jose, CABuilt 1972 · S/N 17261091N20202Lolani Leasing LLC · Los Angeles, CABuilt 1972 · S/N 17261092N20203Wannenburg Thomas · Atlantic Beach, FLBuilt 1972 · S/N 17261093N20207Disheroon Donald · Houston, TXS/N 17261095N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096N2020AComeaux Christopher E · Robeline, LABuilt 1978 · S/N CE-799N2020DPearson Martha A · Walnut Grove, CABuilt 1952 · S/N D-3371N2020GLyon John · Santa Barbara, CABuilt 1958 · S/N 51320N2020WMidland Mist Inc · Midland, GABuilt 1966 · S/N D-8077N2020XCullman Aviation Inc · Cullman, ALBuilt 1965 · S/N 18256120N2020Y707 Solutions LLC · Kalispell, MTBuilt 1971 · S/N 30397N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101N20216Manke Derek E · Canton, GABuilt 1972 · S/N 17261102N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104N20219Koenitzer Judson B · Chetek, WIS/N 17261105N2021CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-212N2021DDockter Travis R · Linton, NDS/N D-3372N2021EEagle Home Medical Corp · Roanoke Rapids, NCBuilt 1978 · S/N D-10158N2021RYergers Garage LLC · Leesport, PABuilt 1969 · S/N 28-5429N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957N20224Obie Aviation LLC · Rogers, ARBuilt 1978 · S/N D-10159N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111N2022CCarriere James M · Navarre, FLBuilt 1959 · S/N TD-189N2022NKauffman Jeffrey B · Leominster, MABuilt 1978 · S/N E-1334N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950N2022WStadelmann Joseph P · Milton, MABuilt 1965 · S/N D-7968N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115N20232Lopez Tail Draggers LLC · Lopez Island, WABuilt 1972 · S/N 17261116N20233Jenkins Robert W · Fredericktown, OHBuilt 1972 · S/N 17261117N20234Emaw Properties LLC · Ketchum, OKBuilt 1978 · S/N CE-801
Back to AD 98-21-21 R1