OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,753

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:81-11-02-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:81-11-02-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.

N38716Spartan Aviation Group LLC · Williamsburg, VABuilt 1977 · S/N 28R-7737109N38717Meiller Richard S · Kill Devil Hills, NCBuilt 1977 · S/N 28R-7737110N38718Vgw LLC · Morgantown, WVBuilt 1977 · S/N 28R-7737111N38771Bmaf LLC · Lewes, DEBuilt 1977 · S/N 28R-7737116N38773Gustafson David · Watertown, SDBuilt 1977 · S/N 28R-7737117N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376N38WJFerguson Scott D · Valparaiso, INBuilt 1975 · S/N 28R-7535327N3904XMoore Jeremy E · Baton Rouge, LABuilt 1975 · S/N 28R-7535347N3913XDesert Flight Academy Inc · Henderson, NCBuilt 1975 · S/N 28R-7535350N3914XLechene Aviation LLC · Indiana, PABuilt 1975 · S/N 28R-7535351N3920XBennett Barry B · El Cajon, CABuilt 1975 · S/N 28R-7535352N3921XBurger Paul D · Cypress, TXBuilt 1975 · S/N 28R-7535353N3923XFerriero Bruce C · Danvers, MABuilt 1975 · S/N 28R-7535354N3928XVanness Aviation LLC · Lawton, NDBuilt 1975 · S/N 28R-7535355N3932XCarbon Six LLC · San Diego, CAS/N 28R-7535356N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362N3944XClark Nicholas J · Wilmington, DEBuilt 1975 · S/N 28R-7535363N39457Pro-Aire Inc · Chisago City, MNBuilt 1978 · S/N 28R-7837297N3949XBlue Ridge Flyers · Leesburg, VABuilt 1975 · S/N 28R-7535365N39513Vitale F Richard · Colts Neck, NJBuilt 1978 · S/N 28R-7837300N39535Flight Services Inc · Headland, ALBuilt 1978 · S/N 28R-7837302N39547Workman Dean B · Newport, RIBuilt 1978 · S/N 28R-7837303N3956XHuth William L · Gulf Breeze, FLBuilt 1975 · S/N 28R-7535366N3957FSeipp Stephen C · Laurel, DEBuilt 1976 · S/N 28R-7635392N3972XSoares Jeffrey A · Aptos, CABuilt 1975 · S/N 28R-7535378N3982XSauve Tiffany A · Racine, WIBuilt 1975 · S/N 28R-7535382N3988XMohlenkamp Jami S · Erie, COBuilt 1975 · S/N 28R-7635002N3996FGrim William S · Kingwood, TXBuilt 1976 · S/N 28R-7635394N40004Tennesen James B · Menomonie, WIBuilt 1977 · S/N 28R-7737126N40010Sain Ricky F · Vale, NCS/N 28R-7737127N40024Teton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 28R-7737128N40068Van Houten Bradley Thomas · Naples, FLBuilt 1977 · S/N 28R-7737131N4011QKolb Michael J · Glenside, PABuilt 1977 · S/N 28R-7737059N402DSDelaware State University · Dover, DEBuilt 1975 · S/N 28R-7635004N404SEBaird Jonathan D · Saint Joseph, MIBuilt 1974 · S/N 28R-7435223N405NDSmith Michael Christopher · Concord, NCBuilt 2004 · S/N 2844113N4065QZajdel Edwin J Jr · Ocean City, MDBuilt 1977 · S/N 28R-7737060N40679Skipper Consulting LLC · Athens, ALBuilt 1977 · S/N 28R-7737132N40697Freiberg Industries Inc · State Center, IABuilt 1973 · S/N 28R-7435113N406SLRhett Howard · Amherst, MABuilt 1974 · S/N 28R-7435293N40724Spirit Flyers Inc · Saint Louis, MOBuilt 1973 · S/N 28R-7435116N40746Flying Vikings Inc · Hayward, CAS/N 28R-7435119N40768Trescone Dennis M · Rochester, MIBuilt 1973 · S/N 28R-7435122N407TLBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 28R-7135013N4081SScheerer Martin · Edina, MNBuilt 1974 · S/N 28R-7435130N40852Air Performance LLC · Kalispell, MTBuilt 1973 · S/N 28R-7435134N40905Martin James Christopher · South Jordan, UTBuilt 1973 · S/N 28R-7435140N40967Mcbroom Darrin · Des Moines, IABuilt 1973 · S/N 28R-7435146
Back to AD 81-11-02 R1