OpenAirDocs.org
AD 81-13-10 R1

Registered aircraft · 4,001

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-13-10-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-13-10-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.

N38538Jurecka Joseph W · Lubbock, TXBuilt 1977 · S/N 28R-7703237N38539Sale Reported · KyivSale reportedBuilt 1977 · S/N 28R-7703238N3854USkymaster Stc LLC · Mena, ARBuilt 1963 · S/N 336-0154N38555Grimm Chris · Burlington, IABuilt 1977 · S/N 28R-7703239N38557Bowyer Ronald D · Keene, TXBuilt 1977 · S/N 28R-7703242N38594Vineyard David D Md · South Lake, TXBuilt 1977 · S/N 28R-7703249N3860URana Jet LLC · Aubrey, TXS/N 336-0160N38610Whiskey Tango Foxtrot Aviation LLC · Broomfield, COS/N 28R-7703252N38625Smith Mark S · Cornville, AZBuilt 1977 · S/N 34-7770329N38636Fre Investments LLC · Enterprise, ALBuilt 1977 · S/N 28R-7703253N38639Mccullough Peter Lee · Doylestown, PABuilt 1977 · S/N 28R-7703255N38664Aerostyles LLC · Colorado Springs, COS/N 28R-7703259N38679Bwt Aviation LLC · Montgomery, ALBuilt 1977 · S/N 34-7770332N38701Sefton James Patrick · Carolina Beach, NCBuilt 1977 · S/N 28R-7703260N38703Ollieboy Productions LLC · Kalispell, MTBuilt 1977 · S/N 28R-7703261N3870VMercury International LLC · Cheyenne, WYBuilt 1977 · S/N R1722266N38720Arrow N38720 LLC · West Des Moines, IABuilt 1977 · S/N 28R-7703264N3873MMorris Air LLC · Hopkinsville, KYBuilt 1978 · S/N 28R-7803198N38741Hoyda Jeffrey A · Tiffin, OHBuilt 1977 · S/N 28R-7703267N38750Mike Mcfadden Enterprises Inc · Laurel, MDBuilt 1977 · S/N 34-7770336N3875UCody Plane Corp · Wilmington, DEBuilt 1964 · S/N 336-0175N38768Ovajet Group Inc · Miami, FLBuilt 1977 · S/N 34-7770085N38776Warnock Air LLC · Eagle, IDBuilt 1977 · S/N 28R-7703274N38791Gehl Timothy E · Houston, TXBuilt 1977 · S/N 28R-7703276N38792Tysdan Aviation LLC · Lake Worth, FLBuilt 1977 · S/N 28R-7703277N38793Siegfried Todd · Brentwood, CABuilt 1977 · S/N 28R-7703278N387WBMckenzie Jan · Fort Collins, COS/N 25-1055N38871Arrow Blue N38871 LLC · Turpin, OKBuilt 1977 · S/N 28R-7703281N38875Landau Victor M · Lake City, FLBuilt 1977 · S/N 28R-7703282N38944Lewis David A · Fairfield, CAFirst renewal noticeBuilt 1977 · S/N 28R-7703284N38981Kreck Blake T · Terrell, TXBuilt 1977 · S/N 28R-7703290N38991Jaquez Francisco P · Corona, NYBuilt 1977 · S/N 28R-7703291N38995Baxter Donald J · Dallas, TXBuilt 1977 · S/N 28R-7703292N389WAOlsen Donald Jr · Silverdale, WABuilt 1966 · S/N 337-0389N38DBWestern Skymaters LLC · Salt Lake City, UTBuilt 1973 · S/N 0002N38TXGlinn Andrew T · Keystone, NEBuilt 1977 · S/N 28R-7703297N3903HMinniti Robert J III · Lansdowne, VAFirst renewal noticeS/N 25-0449N3908XDeutsch Chad A · Evansdale, IAS/N 34-7570308N3909XSmith Aero Inc · Huntington Beach, CABuilt 1975 · S/N 34-7670001N3918XHorton Gregory L · Moorpark, CAS/N 28R-7703001N391XSullinger Billy · Pocahontas, ARBuilt 1976 · S/N 6183CN39252Wildgen Harry J · Ashland, ORBuilt 1989 · S/N 25-1200N3928MSalter James A · San Luis Obispo, CABuilt 1978 · S/N 28R-7803201N3928VThompson Edmond P · Langley, WABuilt 1977 · S/N R1722267N3930XWilson Martin E · Arlee, MTBuilt 1975 · S/N 34-7570317N393CA2050 Services LLC · Burlington, WIBuilt 2001 · S/N 172S8983N393CDBowtie Properties LLC · Dadeville, ALBuilt 2005 · S/N 1478N39466Xing Kong Aviation Service LLC · Atwater, CABuilt 1978 · S/N 34-7870379N39476Neal John W · Pt Pleas Bch, NJBuilt 1978 · S/N 28R-7803348N39477Marti Michael · Kasson, MNBuilt 1978 · S/N 28R-7803349
Back to AD 81-13-10 R1