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.

N710MDSpiller Matthew R · Houston, TXS/N 1126N710TRSln Aviation LLC · Salina, KSBuilt 1977 · S/N R1722768N711ANFlying Mermaid LLC · Aiea, HIBuilt 1975 · S/N 34-7570156N711GCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1975 · S/N 34-7570053N711WCBateman Randy · Lindale, TXBuilt 1994 · S/N 3448049N711WQMerrill Aviation LLC · Anchorage, AKBuilt 1975 · S/N 34-7570183N711XPArsenie Michael D · Roxbury, CTBuilt 1976 · S/N R1722119N712JFN712jf LLC · Laveen, AZBuilt 1968 · S/N 337-0859N71338Beltz Richard D · Lehighton, PABuilt 1994 · S/N 1474N7146YRoberts George M · Houston, TXBuilt 1966 · S/N 337-M0399N7151KKyllo Jeff K · Larimore, NDBuilt 1976 · S/N R1722048N715BDBlack Thomas D · Clearwater, FLBuilt 1976 · S/N 34-7670133N7162CWyoming Valley Air LLC · Old Forge, PABuilt 1975 · S/N 34-7570301N717CS717 Aviation Inc · Alto, NMBuilt 2019 · S/N 82206N717RAWahl Charles S · Cameron Park, CABuilt 1977 · S/N R1722740N717RTAndreini Linda J Trustee · Half Moon Bay, CAS/N 34-7670221N7186CRegistered aircraftBuilt 1973 · S/N 680N718RWWestern Skymasters LLC · Salt Lake City, UTS/N P3370211N71908Mielke Martin W · Valley City, OHBuilt 1973 · S/N 33701500N719WTTait Jesse L · Belton, TXBuilt 1979 · S/N 34-7970362N71DSSchauer Donald Glen · Minden, NVBuilt 1979 · S/N 28R-7931167N71NAYe Services Inc · Bradenton, FLBuilt 1981 · S/N 34-8233017N71SNorth Pine Properties LLC · Queen Creek, AZBuilt 1974 · S/N P3370171N71TXDelano Dan E · Gilbert, AZBuilt 2008 · S/N 72453N7200RDelk George H Jr · Roseland, VAFirst renewal noticeBuilt 1968 · S/N 337M0320N720DGFreedman Roger A · Saint Petersburg, FLBuilt 2002 · S/N 1174N720SBWhalen John F Jr · West Ossipee, NHS/N 337-0407N720TXC A Rob Co LLC · Midland, TXBuilt 2005 · S/N 1564N72113N72113 LLC · Harrah, OKS/N 33701521N721JSWolansky Brad · Plant City, FLBuilt 1997 · S/N 3449024N72250Anderson Gilbert Lc · Palm Bay, FLS/N 33701548N7226V226v LLC · Zachary, LABuilt 1977 · S/N R1722302N72298Ronald D Mcgill Farms Inc · Klamath Falls, ORS/N 33701556N722PSSzendrey James J · Glendale, AZBuilt 1978 · S/N 34-7870125N72342Ampaire Inc · Long Beach, CABuilt 1973 · S/N 33701567N72361Innovative Solutions Inc · Edmond, OKBuilt 1973 · S/N 33701568N72370Vinland Aerodrome Inc · Baldwin City, KSS/N 33701570N723EBWeber Nicholas J · Pinehurst, NCBuilt 2004 · S/N 1387N72406Mercer Don G · Hendersonville, TNBuilt 1973 · S/N 33701577N72444Valiair Lc LLC Trustee · Casper, WYS/N 33701586N72446Minerals 66 LLC · Molt, MTBuilt 1973 · S/N 33701587N72474Dick Ronald J · Fort Wayne, INBuilt 1974 · S/N 33701597N724KRClean Patterns LLC · Mesa, AZBuilt 1976 · S/N R1722050N726ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701661N726EGAtterrissage LLC · Healdsburg, CABuilt 2004 · S/N 1442N726RCiampa Gary T · Sanford, NCBuilt 2011 · S/N 72600N7273FB& G Air LLC · Hudson, FLBuilt 1976 · S/N 34-7770055N727HALinfield Steven J · Westminster, MDBuilt 1978 · S/N 28R-7803289N727JTStory Billy G · Kempner, TXBuilt 1965 · S/N 337-0200N727KCWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1994 · S/N 24-3350
Back to AD 81-13-10 R1