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.

N2406RSale Reported · Lincoln, NESale reportedBuilt 1964 · S/N 18255506N2407GFaull James Aldo · Boise, IDBuilt 1958 · S/N 51707N2407RMyers William J · Colfax, WABuilt 1955 · S/N 26784N2407UFrancis Ronald · Fredericktown, MOBuilt 1963 · S/N 17250007N2408CDoughnut Wings Aviation LLC · Lewes, DEBuilt 1955 · S/N 30708N2408FDawson Brent A · Dillingham, AKS/N 18051608N2408GEl Coyote Ranch LLC · Alzada, MTBuilt 1958 · S/N 51708N2408XWyatt David · Las Vegas, NVBuilt 1965 · S/N 18256308N2409XHarrison Nicholas R · Midland, NCBuilt 1965 · S/N 18256309N2409YLow Go Flyers Inc · Jonesville, LABuilt 1955 · S/N 31967N240AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881731N240AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496650N240DMRussell Robert Q · Genoa City, WIBuilt 1977 · S/N 17269757N240GBSchumaker Joseph W Jr · Petersburg, MIBuilt 1966 · S/N 310K0188N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221N240JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020010N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108N240LHWitt Aaron K · Hooker, OKBuilt 1966 · S/N 30-1240N240LMChamblis John L · Webb, MSBuilt 1966 · S/N 18257601N240MBail Air LLC · Port Saint Lucie, FLBuilt 1970 · S/N D-9211N240MKFly254 LLC · Waco, TXS/N 28-26527N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168N240RWestex Telco LLC · Abilene, TXS/N 3449496N240RATop Aircraft Leasing LLC · Wilmington, DES/N 310Q0108N240RCIntegrity Sales And Auction LLC · Merrill, WIBuilt 1980 · S/N 310R-1869N240RG182rg LLC · Bellevue, WABuilt 1981 · S/N R18201783N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273N240TFAir Fleet Holdings LLC · Missoula, MTBuilt 2023 · S/N 4496558N240UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020161N2410CChasin Tails Inc · Gouldsboro, MEBuilt 1954 · S/N 30710N2410DWeaver James C · Boise, IDFirst renewal noticeBuilt 1952 · S/N 20562N2410EKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17271272N2410LSammons Mitchell · Belgrade, MEBuilt 1966 · S/N 17255610N2410QRegistered aircraftBuilt 1966 · S/N 18257610N2410UYellow Breast Aviation LLC · Christiansted, VIS/N 17250010N2410XKitsap Aviation Squadron · Southworth, WABuilt 1965 · S/N 18256310N2411Custom Flight Rnh · New Richmond, WIBuilt 1955 · S/N D-4282N2411CMacadams Christopher L · Bloomington, MNS/N 30714N2411DBinsky Lawrence A · Bexley, OHS/N 20563N2411LEfinger John M · Cresson, TXS/N 17255611N2411MAltshuler David · Cambridge, MAS/N 28R-7803126N2411RLowery Jerry W · Cartersville, GABuilt 1964 · S/N 18255511N2411USiemens Jonathan Lee · Seminole, TXBuilt 1963 · S/N 17250011N2411YMullings Michael A · Orange, NJBuilt 1962 · S/N 17249711N2412CRigid Oilfield Services LLC · El Reno, OKS/N 30712N2412MChristensen Broadcast Group Inc · Watertown, SDBuilt 1977 · S/N 28R-7803127N2412QTickemyer David K · Warrensburg, MOBuilt 1966 · S/N 18257612N2412RGagnon David D · New Market, ALS/N 28-5615N2412UHill Brock E · Palouse, WABuilt 1963 · S/N 17250012N2413Gabardi Duane A · Manitou Springs, COBuilt 1963 · S/N 2624
Back to AD 98-21-21 R1