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.

N311SRed Rock Construction Inc · Hydro, OKBuilt 1964 · S/N 30-328N311SFBaymag Aviation LLC · Mountain Home, ARBuilt 1968 · S/N 18259047N311SKDoyle Thomas Michael · New City, NYBuilt 1976 · S/N 310R0687N311WCIndy Aviation LLC · Dover, DES/N 24-1583N311XStevens Adam · Dacono, COBuilt 1963 · S/N 2592N311ZRegistration Pending · Rockford, ILRegistration pendingBuilt 1960 · S/N CD-222N3120BRustad Scott K · Minot, NDBuilt 1952 · S/N 25362N3120ETandberg Kjell · Beverly Hills, FLBuilt 2005 · S/N 3257400N3120FLengyel Roger · Santa Fe, NMBuilt 1966 · S/N 18257220N3120MCowtown Aviation LLC · Aledo, TXBuilt 1987 · S/N CE-1204N3120QLinda In The Sky LLC · Webster, MNBuilt 1967 · S/N 18258120N3120RBulang Investments LLC · Newbury, NHS/N 18258520N3120TMcbride Matthew T · Eagle River, WIBuilt 2006 · S/N 3257417N3120WWiese Chuck F · Portland, ORBuilt 1973 · S/N TC-1645N3121CUnkefer Edward Lowell · Waynesboro, VAS/N E-2404N3121DFrey Jerry P · Fallon, NVBuilt 1955 · S/N 31919N3121FLily Chris H · Ocala, FLBuilt 1966 · S/N 18257221N3121VCochise Community College · Douglas, AZBuilt 2006 · S/N 2843626N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410N31222Dc Air LLC · Lebanon, MOBuilt 2004 · S/N 3257354N3122AJohns William D · Lodi, CABuilt 1953 · S/N 25766N3122EKantec Inc · Cary, NCBuilt 1999 · S/N 2843250N3122LE C G Aviation Inc · Orange, CABuilt 1965 · S/N 310J0122N3122MMiller-Jackson Co Inc · Oklahoma City, OKBuilt 1984 · S/N EA-416N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3122STecumseh Skydiving School LLC · Tecumseh, MIBuilt 1964 · S/N 18255622N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431N3122YJti Management LLC · Colfax, WAS/N 18254122N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922N3123EKanase Padmaneel B · Amarillo, TXS/N 17271444N3123QDarkhorse Six Inc · Boerne, TXBuilt 1967 · S/N 18258123N3123RHs Aviation Holdings LLC · Eagle, IDBuilt 1967 · S/N 18258523N3123SGabin LLC · Tulsa, OKBuilt 1964 · S/N 18255623N3123WSullivan Dan · Kingwood, TXBuilt 1973 · S/N E-500N3123YAbecca Corporation · Jackson, MIBuilt 1962 · S/N 18254123N31241Hotel Charlie Aero LLC · Marshville, NCBuilt 2006 · S/N 3246234N3124AWolstenholme Robert · Line Lexington, PABuilt 1953 · S/N 25768N3124BUsda Aphis Ws Atoc · Cedar City, UTS/N 3543N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224N3124RMidland Liberty LLC · Midland, MIBuilt 1967 · S/N 18258524N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923N3125FHall Aircraft LLC · Kenai, AKS/N 18257225N3125GEastern Kentucky University · Richmond, KYS/N 4496214N3125LOxley Lake Solutions LLC · Lawton, MIBuilt 1965 · S/N 310J0125N3125QSunrise Aviation Llp · Gig Harbor, WABuilt 1967 · S/N 18258125N3125WRowe Benjamin Stratton · Nome, AKBuilt 1959 · S/N 50584N3125YOberdoerster Timothy L · Concord Township, OHS/N 18254125N3126ALutz Adam R · Kodiak, AKBuilt 1953 · S/N 25770
Back to AD 98-21-21 R1