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.

N61846Wood James P · Greenbank, WAS/N 17264838N6192KSmith Chris Sean · Pendleton, SCBuilt 1976 · S/N R1722034N6194HJones Frederick W · Burgaw, NCBuilt 1977 · S/N 28R-7803096N619BPGay Brandon W · Campbellsville, KYBuilt 2003 · S/N 1313N619DCHarvard Air Taxi LLC · Andover, MABuilt 1979 · S/N 34-7970495N619DT6 Dt Flyers LLC · Corpus Christi, TXS/N P3370123N61ABj Aviation LLC · Beaver Meadows, PABuilt 1968 · S/N 337-0886N61DPDjp Enterprises Inc · Chandler, TXBuilt 1981 · S/N 348133043N61HBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3449217N61LMBowling Realty Inc · Jackson, MSBuilt 1981 · S/N 34-8133192N62003Valpey R Wesley Jr · Medford, MEBuilt 1974 · S/N 6056CN62015Bender Evan D H · Linville, VABuilt 1974 · S/N 6059CN62034Williams Robert W · Anchorage, AKBuilt 1974 · S/N 6067CN62037Martin Terence R · Newport, ORBuilt 1975 · S/N 6071CN62039Schuerman William R · Arlington, WABuilt 1975 · S/N 6072CN62040Comm William · Mulino, ORBuilt 1975 · S/N 6073CN62043Hardy John R · Wasilla, AKBuilt 1975 · S/N 6074CN62044Pentz Geoff M · Port Ludlow, WABuilt 1975 · S/N 6081CN62045Lewis John R · Juneau, AKBuilt 1975 · S/N 6078CN62051Anderson John · El Paso, TXBuilt 1975 · S/N 6087CN62062Atlas Air LLC · Salt Lake City, UTBuilt 1975 · S/N 6101CN62063Harrison Kelcey A · Galena, AKS/N 6088CN62066Whitfield Timothy D · Fairfield, NCBuilt 1975 · S/N 6076CN62067Cole Matthew M · San Jose, CAS/N 6089CN62070Wydra Richard J Jr · Mchenry, ILBuilt 1975 · S/N 6092CN6207NAdvanced Sport Psychology LLC · Orlando, FLBuilt 1980 · S/N 34-8070306N621EDPhantom Aviation LLC · Ormond Beach, FLBuilt 1977 · S/N 34-7770165N621LGAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2002 · S/N 3449296N6220FHeberle David B · Castroville, TXBuilt 1965 · S/N 337-0220N62217Wieken Peter J · Mount Joy, PABuilt 1968 · S/N R1720085N6226Lewis Jay C · Spanaway, WABuilt 1967 · S/N R172-0227N6228FLynch Kent · Edwards, ILBuilt 1965 · S/N 337-0228N623WCWilkinson Craig R · Parker, AZS/N 28R-7931203N6241CK&M Aviation LLC · Kemah, TXBuilt 1978 · S/N 34-7870145N6243FReim Rodney D · Enid, OKBuilt 1965 · S/N 337-0243N6243KAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N R1722036N6244FRegistered aircraftBuilt 1965 · S/N 337-0244N6245FCosse Harold C · Euless, TXS/N 337-0245N6246FCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1965 · S/N 337-0246N6248FStevenson David E · Grundy, VAS/N 337-0248N624KRSafe Charter Inc · Bethesda, MDBuilt 2003 · S/N 1314N6250FNeeper Philip A · Fayetteville, NCBuilt 1965 · S/N 337-0250N6263CKasallis Thomas G · Midlothian, TXBuilt 1978 · S/N 28R-7803215N6267FSkymaster Company LLC · Dover, DES/N 337-0267N626FMN626fm LLC · Brunswick, GABuilt 1979 · S/N 34-7970142N626WAZarlenga And Seltzer Inc · Palmyra, PABuilt 1977 · S/N 34-7770303N6276FHubler Bruce F · Caldwell, IDS/N 337-0276N627FDPacific Health Care Staffing Inc · Rancho Cucamonga, CABuilt 1978 · S/N 28R-7803187N6284FMathews Wade A · Wichita Falls, TXS/N 337-0284N6288FAircraft Leasing And Service · Malabar, FLBuilt 1965 · S/N 337-0288
Back to AD 81-13-10 R1