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.

N2809UBleskan Erick J · New Berlin, WIBuilt 1963 · S/N 17250409N280AASchurr Steven M · Nederland, COBuilt 1960 · S/N D-6375N280AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496511N280ASBravo Aviation Club LLC · Cary, NCBuilt 1977 · S/N 32R7780155N280BGD&J Aviation LLC · Gotha, FLBuilt 2002 · S/N 2842167N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154N280FGFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496525N280HB280hb LLC · Brighton, MIBuilt 1966 · S/N 18256901N280HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2843733N280JBS & S Properties Inc · N Kansas City, MOBuilt 1998 · S/N 3257043N280JPDraaisma Jacob Jr · Middleville, MIS/N 50825N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450N280NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844014N280PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841230N280SWKatie Investments Inc · Little Rock, ARBuilt 1978 · S/N 20604561N280TCNobles Gary D · Fairview, TXS/N 28-21227N28103Hawksyntketics LLC · Jacksonville, FLS/N 78-31150N28106Adams Charles J · Santa Maria, CAS/N 78-30874N2810AWiggin Connery A · Lakeside, MTBuilt 1969 · S/N D-9056N2810FDancing On Blue Lc · Las Vegas, NVBuilt 1966 · S/N 18256910N2810KWair Inc · Mount Vernon, WABuilt 1979 · S/N 18053081N2810QMcdowell Kevin J · Williamsburg, VABuilt 1971 · S/N 17259810N2810RSeller Mark E · Hutchinson, MNBuilt 1967 · S/N 18258410N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N2810UN2810u LLC · Delray Beach, FLBuilt 1963 · S/N 17250410N28110Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496513N28111Truair LLC · Shady Shores, TXBuilt 1978 · S/N 79-30909N281123b Aviation LLC · Tyler, TXBuilt 1978 · S/N 78-30889N28114Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496514N28115Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 4496515N28119Page Gregory G · Roosevelt, UTBuilt 1978 · S/N 78-31146N2811CBeyer James C · Fayetteville, TNBuilt 1954 · S/N 26354N2811FLien Craig C · Plains, MTBuilt 1966 · S/N 18256911N2811KHayward Houston C · Lansdale, PABuilt 1979 · S/N 18053082N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296N2811WRegistered aircraftAssigned, pending cancellationS/N TD-66N2811YCotti Kevin P · Plymouth, MABuilt 1961 · S/N 18253811N28127Ultimate Derby LLC · Celina, TXBuilt 1979 · S/N 80-30972N28128Klaw-N5365g LLC · Wichita Falls, TXBuilt 1979 · S/N 80-30978N28129Niles Aviation Of Kansas LLC · Arkansas City, KSBuilt 1979 · S/N 80-30970N2812ABlough Christopher D · Middlebury, INBuilt 1969 · S/N CD-1233N2812CSmallwood Nathan M · Ellicott City, MDS/N 26355N2812KSylvester John A · Hereford, AZBuilt 1979 · S/N 18053083N2812LHarris Partnership · Conway, ARBuilt 1967 · S/N 17256012N2812QHammond David J · Chesterfield, VABuilt 1971 · S/N 17259812N2812RBullin Keith · Bryan, TXBuilt 1967 · S/N 18258412N2812UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250412N2813Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010052N28130Gorman Neal H · Bend, ORBuilt 1980 · S/N 80-30981
Back to AD 98-21-21 R1