OpenAirDocs.org
AD 98-21-21 R1

Registered aircraft · 85,616

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.

N1155FDejesus Rodolfo B · Murfreesboro, TNBuilt 1966 · S/N 17254750N1155GHartwig Cody · Seattle, WABuilt 1981 · S/N 24-1245N1155YM20 Inc · Aledo, TXS/N 24-1248N1156BN1156b Corp Trustee · Wilmington, DEBuilt 1981 · S/N 24-1250N1156GWilliams Michael E · Horseshoe Bay, TXFirst renewal noticeBuilt 1981 · S/N 25-0639N1156KN1156k 231 LLC · Dearborn Heights, MIBuilt 1982 · S/N 25-0651N1156MJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 25-0642N1156NHenry Richard · Fort Campbell, KYBuilt 1981 · S/N 24-1251N1156TAero 1 LLC · Kalispell, MTBuilt 1975 · S/N D-9761N1156UShamu Inc · Wilmington, DEBuilt 1981 · S/N 24-1253N1156ZHeyboer Timothy · Pacific Grove, CABuilt 1982 · S/N 24-1286N11575Pyle Howard H · Cornelius, ORBuilt 1950 · S/N 19540N1157AMach Holdings LLC · Aurora, COBuilt 1982 · S/N 24-1257N1157FKiss George C · Bangor, PAS/N 17254752N1157GPennington P · The Colony, TXBuilt 1982 · S/N 25-0729N1157JAvinate LLC · Orlando, FLS/N 25-0643N1157KBistline Luke W · Tooele, UTS/N 25-0644N1157LFurf Air Inc · Venice, FLBuilt 1982 · S/N 25-0654N1157MWhf Aviation LLC · Jamestown, OHBuilt 1975 · S/N 18264235N1157PPourcho William S · Bloomfield Hills, MIFirst renewal noticeS/N 25-0647N1157QRrc Inc · Madison, MSBuilt 1975 · S/N U20602848N1157SDig2fly LLC · Sandpoint, IDBuilt 1978 · S/N 317812093N1157TSalloom Mary M · Gaithersburg, MDBuilt 1975 · S/N E-640N1157UMooney LLC · Lisbon, NYBuilt 1982 · S/N 24-1261N1157WAdams Chad D · Dayton, ORBuilt 1970 · S/N U20601578N1157XAscend Aviation LLC · Bountiful, UTBuilt 1975 · S/N 28-7525294N1157ZKodet David · Minnetonka, MNBuilt 1982 · S/N 24-1262N11581Jarratt Michael A · Lake Havasu City, AZBuilt 1982 · S/N 24-1289N1158DCondry Sean T · Lake Lotawana, MOBuilt 1982 · S/N 24-1264N1158FAmerican Pride Aviation LLC · Newport Beach, CABuilt 1966 · S/N 17254753N1158HOs Flight LLC · Double Springs, ALS/N 28-7715311N1158JSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 24-1267N1158KGaithersburg Mooney Flyers LLC · Rockville, MDBuilt 1982 · S/N 24-1349N1158NAviation Endeavor Society LLC · Leander, TXBuilt 1981 · S/N 25-0648N1158PLorenzo Walker Institute Of Tech · Naples, FLBuilt 1955 · S/N 23-171N1158ZMoffitt Carl A · Orange, CAS/N U20606634N1159DZollars Thomas B · Dallas, TXBuilt 1982 · S/N 25-0652N1159FRodimel Troy R · Greenwood, INS/N 17254754N1159PMccann Matthew · Egg Hbr Twp, NJBuilt 1982 · S/N 24-1296N1159TNxtday Aire LLC · Dover, DEBuilt 1974 · S/N TC-1784N1159XBarrett Tyler J · Cullman, ALS/N 28-7505217N115AWMillican Marc J · Anchorage, AKBuilt 1976 · S/N 18502941N115CA8k Entertainment Inc · Wells, MEBuilt 1981 · S/N D-10371N115CCPlane Guys LLC · Saint Onge, SDBuilt 1979 · S/N 7930931N115CKSchmick Kenneth R · Fond Du Lac, WIS/N 35281N115CSBurger Aviation LLC · Brandon, MSBuilt 2000 · S/N 32-46177N115CWWhitlock Gary D · Melbourne, FLBuilt 1974 · S/N 21060520N115DCLong Jerry D · Solvang, CABuilt 1973 · S/N 28R-7335405N115DLJ & S Consulting Solutions LLC · Middletown, DEBuilt 1961 · S/N TD-481N115DXPiper Aircraft Inc · Vero Beach, FLS/N 28010102
Back to AD 98-21-21 R1