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.

N25698Tupelo Aeronautics Inc · Tupelo, MSS/N TC-1603N2569KHarris Curtis M · Anchorage, AKS/N 18052991N2569QWatch Ya Head Aviation I LLC · West Haven, UTBuilt 1977 · S/N 28-7790407N2569UHalladay Roy · Erie, COBuilt 1963 · S/N 17250169N2569WDenenny Richard H · Spokane Valley, WABuilt 1965 · S/N 930N2569ZEitilt Aviation LLC · Parker, COBuilt 1963 · S/N 185-0569N256AAAlf Ix LLC · Chicago, ILBuilt 2019 · S/N 4496476N256ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496067N256DBNortheastern Gastroenterology Associates Pa · Summit Hill, PABuilt 1998 · S/N E-3081N256DDSch Aviation Inc Trustee · Sporle Kings LynnS/N 24-1080N256DMBailey Joseph H · Port Saint Lucie, FLBuilt 1978 · S/N 32R-7885028N256FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020056N256MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881447N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958N256SAAirview Inc · Ligonier, PABuilt 1983 · S/N R18201967N256SGCalache Michael · Fredon, NJBuilt 1976 · S/N 32-7640094N256TCHyder Racing LLC · Kalispell, MTBuilt 1967 · S/N TG-39N256TETimberline Excuvation Inc · Fairbanks, AKBuilt 1969 · S/N U2061336N256ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881611N25704Arrison Frank J · Doylestown, PABuilt 1973 · S/N E-475N2570LHerman John K Jr · Flagler, COBuilt 1967 · S/N 17255770N2570QGolden Thomas J · Bishop, GAS/N 18257770N2570RSkyblazers LLC · Boones Mill, VABuilt 1967 · S/N 18258270N2570UJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016036N2570ZLucci Robert J · Long Lake, NYBuilt 1963 · S/N 185-0570N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540N2571CLane Steven A · Rockwood, MEBuilt 1952 · S/N 26215N2571DLiebsch Greg A · Gilbert, AZBuilt 1952 · S/N 20723N2571GGolf Air LLC · Anchorage, AKBuilt 1959 · S/N 51871N2571LClements Jim L · Cushing, OKBuilt 1967 · S/N 17255771N2571MBoston Breeze Aviation LLC · Woburn, MABuilt 1977 · S/N 28-7890258N2571QLubbe Klaus · Bethlehem, NHS/N 28-7790408N2571XPray Aviation Inc · Augusta, KSS/N 28-8516037N25720Smile Air LLC · Macomb, MIBuilt 1973 · S/N E-479N25722Mitchell Brian J · Boise, IDBuilt 1963 · S/N 18051274N2572GMorgan Nathan · Boise, IDBuilt 1959 · S/N 51872N2572RMladejovsky Michael G Trustee · Paulden, AZBuilt 1967 · S/N 18258272N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332N2572UVan Scoy Bridget Anne · Shavertown, PAS/N 28-8016038N2572WFlournoy Thomas H · Port Republic, NJBuilt 1965 · S/N 3273N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390N2573KDonham Sonjia F · Portland, ORBuilt 1978 · S/N 18052995N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173N2573WTrail Air LLC · Springdale, ARBuilt 1965 · S/N 3274N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073N2573YFritz David C · Lincoln, NEBuilt 1960 · S/N 17247906N25745Bird Dog Aviation LLC · Kalispell, MTS/N TE-949N2574DDumm Wesley J · Kodiak, AKBuilt 1952 · S/N 20726
Back to AD 98-21-21 R1