OpenAirDocs.org
AD 71-13-01 R1

Registered aircraft · 6,915

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:71-13-01-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:71-13-01-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.

N206RAAcord Transportation Inc · Chandler, OKBuilt 2021 · S/N T20609654N206RPFinley Aviation LLC · Fort Worth, TXBuilt 2005 · S/N T20608516N206RR206 Adventures LLC · San Juan, PRBuilt 2013 · S/N T20609102N206SJUrbana Aviation LLC · Woodstock, OHBuilt 1998 · S/N T20608007N206TBAir Supply LLC · Tuscumbia, ALBuilt 2025 · S/N T20609813N206UESmith Peter I Trustee DBA · Ocala, FLS/N T20608744N206VBN206vb LLC · Batavia, OHBuilt 2013 · S/N T20609084N206VSBos Ranch LLC · Reno, NVBuilt 1999 · S/N T20608030N206WEM&B Holdings LLC · Verdi, NVS/N T18208635N206WKKaw Corp · Mcallen, TXBuilt 2001 · S/N T20608318N206WYAerotrust Services Corp Owner Trustee · Wilmington, DEBuilt 2000 · S/N T20608187N206YPIm Aviation LLC · Laredo, TXBuilt 2020 · S/N T20609620N2070RRosies Procurment LLC · Midlothian, TXBuilt 1997 · S/N 27-0227N2077NLilylands Aviation LLC · Redvale, COBuilt 2004 · S/N T18208225N2078BD & P Jones Enterprises Inc · Santa Cruz, CABuilt 1979 · S/N 32R-7987022N2079XDe Flyers LLC · Vicksburg, MIBuilt 1979 · S/N 32R-7987120N207ALU S Imaging Flight Ops LLC · Bartow, FLBuilt 2015 · S/N T20609163N207CDCheek Gary L · Chandler, AZBuilt 2007 · S/N T18208791N207MAStreamline Aviation LLC · Battlefield, MOS/N 32-40923N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092N2080QHyperion Enterprises LLC · Warrenton, VABuilt 2005 · S/N T18208450N20816Dawson Matthew · Springfield, MOBuilt 1980 · S/N 32R-8029001N20817Beard Russell G · Goodyear, AZBuilt 1978 · S/N 32R-7887179N2081AKing David M · Ormond Beach, FLBuilt 1978 · S/N 32R-7885283N2087ASmith Morris A · Odessa, TXBuilt 1978 · S/N 32R-7987001N20887N20887 LLC · Augusta, GABuilt 2005 · S/N T18208452N208DGDelta Golf Aviation LLC · Pompton Plains, NJBuilt 2008 · S/N T20608866N208FT423 East Young LLC · Warrensburg, MOBuilt 2005 · S/N T20608573N20928Shelley Aaron J · Corbin, KYBuilt 1978 · S/N 32R-7887182N2093CJerles William R Jr · Roberta, GABuilt 1978 · S/N 32R-7985022N2095JAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2005 · S/N T20608554N2095SMrk Aviation LLC · Delray Beach, FLBuilt 2004 · S/N T20608442N2096ARegistration Pending · Malden, MORegistration pendingBuilt 1978 · S/N 32R-7985001N2098CLynch Stephen J · Stamford, CTBuilt 2004 · S/N T18208228N2099YThompson And Harvey Holdings LLC · Orcutt, CABuilt 2004 · S/N T20608444N209CSMat Air LLC · Bridgeport, TXBuilt 2011 · S/N T20609002N209PDModesto Police Department · Modesto, CABuilt 2012 · S/N GA8-TC 320-12-186N20ADDdd Partnership · Davis, CABuilt 2020 · S/N T20609612N20BBlackard William R Jr · Jacksonville, FLBuilt 1976 · S/N 32R-7680387N20BBSteller Air Charter LLC · Jacksonville, FLBuilt 1983 · S/N 31P-8414005N20BWN220kw LLC · Moses Lake, WABuilt 1976 · S/N 32R-7680355N20CNRegistration Pending · Bedford, PARegistration pendingBuilt 2019 · S/N T20609584N20DBLsn Air LLC · Morrison, COBuilt 2004 · S/N T18208331N20FQJag Capital LLC · Cocoa, FLBuilt 1986 · S/N 638N20FRNorton Justin William · Albuquerque, NMS/N 639N20FZSharp Randy L · Rocklin, CABuilt 1986 · S/N 644N20GFVerbil Christopher J Trustee · Los Altos, CABuilt 1987 · S/N 645N20KMMozur Matthew Allen · Danvers, MABuilt 1985 · S/N 558N20KTWatson Toby · Sheboygan, WIBuilt 2008 · S/N 4692072N20LUCamas Wings LLC · Camas, WAS/N 685
Back to AD 71-13-01 R1