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.

N2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeBuilt 1967 · S/N 18258484N2884TBonner John A · Riverside, CABuilt 1972 · S/N 28-7225266N2884UEast Tenn Pilots Club Inc · Knoxville, TNBuilt 1963 · S/N 17250484N2884XAngle Of Attack Flying Company LLC · Springfield, MOBuilt 1979 · S/N 28-7916511N2884YTri-Aviation Inc · Amarillo, TXBuilt 1962 · S/N 18253884N28852Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843732N2885BIxi LLC · West Bloomfield, MIS/N 28-7916513N2885CCassee Udo · Anchorage, AKBuilt 1954 · S/N 26428N2885DLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1979 · S/N 28-7990520N2885FDunkly Daniel L · Chico, CABuilt 1979 · S/N 28-7990521N2885GWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8090001N2885KDierkes Steven P · Henderson, NVBuilt 1979 · S/N 28-7990525N2885LBlevens George A Jr · Franklin, KYS/N 17256085N2885MGuilford Lakes Aviation LLC · Greensboro, NCS/N 28-7990526N2885NBrandy Wine Flight School · West Chester, PAS/N 28-7990527N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318N2885UEda4 LLC · Cresson, TXBuilt 1963 · S/N 17250485N2885YMiner Bradford Aviation LLC · Spanish Fork, UTS/N 18253885N2886CParks Walter G · Chugiak, AKBuilt 1954 · S/N 26429N2886FWeldon Larry W · Titusville, PABuilt 1966 · S/N 18256986N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886N2886TAtkins Joseph Van · Lenoir, NCBuilt 1972 · S/N 28-7225268N2886UVon Linsowe David J · Vero Beach, FLBuilt 1963 · S/N 17250486N2886WBushong Chistopher L · Gulf Shores, ALS/N D-9512N2886XMiller Robert Joseph · Fence Lake, NMBuilt 1979 · S/N 28-7990530N2887CKris Noone Air LLC · Wilmington, DEBuilt 1954 · S/N 26430N2887DTwelve Bits LLC · Fort Lauderdale, FLBuilt 1979 · S/N 28R-7918197N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360N2887LMello Stephen F · Ludlow, MABuilt 1967 · S/N 17256087N2887QAvalon Global Aviation Inc · Lakeland, FLS/N 28R-7918199N2887RNaylor Michael Scott · Modesto, CABuilt 1967 · S/N 18258487N2887TSanetra George W · Gary, INBuilt 1972 · S/N 28-7225269N28887Danos Laura S · Hampton Falls, NHBuilt 1979 · S/N 28-7990432N2888CGutwein Harvey R · Francesville, INS/N 28-7911225N2888FLynch Neil E · Ceresco, MIBuilt 1966 · S/N 18256988N2888GClark Larry K · Sedalia, COBuilt 1979 · S/N 28-7911226N2888KBooth William R Jr · Sterling, AKBuilt 1979 · S/N 18053119N2888QChilds William C · Bridgeport, ALS/N 17259888N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153N2888UBodo Martin Trustee · Los Altos Hills, CABuilt 1963 · S/N 17250488N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433N2889CStowell Ronald A · Westminster, COBuilt 1954 · S/N 26432N2889FLander Kirt E · Kingman, AZBuilt 1966 · S/N 18256989N2889GValkyrie Holdings LLC · Lincoln, NES/N 28-7911228N2889LSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N 17256089N2889QAshworth Mark · Stow, OHS/N 28-7921083N2889RAircraft Structural Repair Inc · Hamilton, MTBuilt 1967 · S/N 18258489N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154
Back to AD 98-21-21 R1