OpenAirDocs.org
AD 98-21-21 R1

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

N2481UWilliams Jeremy · Searsport, MES/N U20602380N2481YFellers Farms LLC · Burlington, OKBuilt 1962 · S/N 17249781N2482CMiller Richard W · Bellingham, WABuilt 1954 · S/N 30782N2482DRiegel Frederick E · Houston, OHBuilt 1952 · S/N 20634N2482LTrubowicz Maciej Piotr · Cornelius, NCBuilt 1966 · S/N 17255682N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682N2483DBrogden Aviation LLC · Olathe, KSBuilt 1952 · S/N 20635N2483FMiller Clinton J · Traverse City, MIBuilt 1966 · S/N 18051685N2483GLenox Mark W · Idaho Falls, IDS/N 51783N2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583N2484CLejeune Aerial Applications LLC · Basile, LABuilt 1954 · S/N 30784N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686N2484LLuv2fly LLC · San Antonio, TXS/N 17255684N2484UFiske James K · North Andover, MABuilt 1963 · S/N 17250084N2485DDraggin Tail Pilots LLC · Prospect, PABuilt 1952 · S/N 20637N2485GBack Country Guys LLC · Prescott, AZBuilt 1959 · S/N 51785N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685N2485RGriffith Kyle R · Talihina, OKBuilt 1969 · S/N 28-5633N2485XLostetter Evan · Bakersfield, CABuilt 1985 · S/N 28-8516069N2485YMcdonald Gregory S · Mena, ARBuilt 1962 · S/N 17249785N2486CArmstrong Patrick Trustee · Bishop, CABuilt 1954 · S/N 30786N2486GDenton Bob · Nampa, IDBuilt 1959 · S/N 51786N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586N2486UGuardian Flight LLC · South Jordan, UTS/N 34-7970446N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386N2486YCarfinder LLC · Huntington Station, NYBuilt 1962 · S/N 17249786N2487DBlue Four Aviation LLC · North Pole, AKBuilt 1952 · S/N 20639N2487GRegistration Pending · Aledo, TXRegistration pendingBuilt 1959 · S/N 51787N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344N2487UBaske Scott E · Hanna, INBuilt 1963 · S/N 17250087N2487YBradley Jeff C · Schertz, TXS/N 17249787N2488DStokes David R · Sleepy Hollow, ILBuilt 1952 · S/N 20640N2488GRumley Orville C · Minco, OKBuilt 1959 · S/N 51788N2488MMeads Rodney L · Camden, NCBuilt 1977 · S/N 28-7816289N2488PPs Engineering Inc · Lenoir City, TNBuilt 1999 · S/N 2843282N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588N2488USchafer Gerhard Walter · Fairbanks, AKS/N 17250088N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388N2489CRegistered aircraftBuilt 1954 · S/N 30789N2489DClark Joseph F III · New Smyrna Beach, FLBuilt 1952 · S/N 20641N2489GRogers Gregory J · Plesant Hill, MOBuilt 1959 · S/N 51789N2489LCalifornia Aviation Services Inc · Riverside, CABuilt 1966 · S/N 17255689N2489UKauachi Melik · Brownsville, TXS/N 17250089N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389N248AMDesfosse Donald J Trustee · Andover, MABuilt 1996 · S/N 3246054N248BFotheringham Jack · Palmer, AKS/N 28-7505135N248BNEshleman James E · Yucaipa, CAS/N 28R-7703126N248CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881003
Back to AD 98-21-21 R1