OpenAirDocs.org
AD 71-13-01 R1

Registered aircraft · 6,916

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.

N41676American Roadways LLC · Missoula, MTBuilt 2000 · S/N 4636268N4167AWilliams Mirage LLC · Denver, COBuilt 2000 · S/N 46-36254N4167CSsp Aviation LLC · Aurora, OHBuilt 1999 · S/N 4636201N4167DCraft Air Ventures LLC · Lake Jackson, TXBuilt 2000 · S/N 3257138N4167NS&T Aviation LLC · Missoula, MTS/N 3257170N4167RZorychta Mary Ann · Clinton, ARBuilt 1968 · S/N 32-40483N4167SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 3257153N4168RJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 32-40484N4168SDrew Dennis M · Danville, CABuilt 2000 · S/N 3257159N4169RWollen Mark A · Poway, CABuilt 1968 · S/N 32-40566N4169WSebago Flight Service Inc · Cumberland, MEBuilt 2014 · S/N T20609154N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094N4170VPi High Flight LLC · Lancaster, PABuilt 2000 · S/N 3257141N4170WWilson Troy L · Raton, NMBuilt 1967 · S/N 32-40249N4172RRedemption Inc · Kodiak, AKBuilt 1968 · S/N 32-40505N4172TMajor Michael S · Ogden, UTBuilt 2000 · S/N 3257158N4173AE Hospital Services Inc · Houston, TXFirst renewal noticeBuilt 2000 · S/N 3257146N4173RWilliams Paul D · Gunnison, COBuilt 1968 · S/N 32-40507N4173WGordon Jacques L Dmd · Atlanta, GABuilt 1967 · S/N 32-40252N4174RSouth Butte LLC · Cedar City, UTBuilt 1968 · S/N 32-40508N4174USouthern Siding And Window Corp · Augusta, GABuilt 2002 · S/N 3257308N4174WAndrews Steven J · Warner Robins, GABuilt 1967 · S/N 32-40253N4174ZCaledonia Air LLC · Palm Beach, FLBuilt 2000 · S/N 3257179N4175KYu Christopher · Menlo Park, CABuilt 2000 · S/N 4636294N4175WBauder Plane LLC · Hatfield, PABuilt 1967 · S/N 32-40255N41769Tipton John H III · Chesterfield, MOBuilt 1974 · S/N 32-7440105N4176TAir Ninja LLC · Wilmington, NCBuilt 1999 · S/N 3257124N41799Registration Pending · Panama City Beach, FLRegistration pendingBuilt 2000 · S/N 4636257N4179WCavada Arthur H · Jamul, CABuilt 1967 · S/N 32-40262N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467N417JMTulsa Aviation Partners LLC · Tulsa, OKBuilt 2000 · S/N 18280837N417JSCockapoo Air LLC · Naperville, ILBuilt 1998 · S/N 4636183N417MAT&G Aviation Services LLC · Temple, TXBuilt 2007 · S/N 4636415N417MXAw Foxtrot LLC · Cuero, TXBuilt 2008 · S/N 4692017N417PDDagenais Paul Robert · Escanaba, MIBuilt 2021 · S/N T20609632N417RKAutavia Inc Trustee · Wilmington, DEBuilt 1999 · S/N 4636249N417STM500 LLC · Lewisville, TXBuilt 2017 · S/N 4636714N4181WMission Flight · El Monte, CABuilt 1967 · S/N 32-40263N4182AHidden Amphibians LLC · Dover, DES/N 3257182N4182RSchmidt Tim A · Holdrege, NEBuilt 1968 · S/N 32-40513N4182WNovember Four One Eight Two Whiskey LLC · Fulton, MOBuilt 1967 · S/N 32-40264N4183WTate Aviation LLC · Camden, DEBuilt 2000 · S/N 3257183N41847Saratoga N41847 LLC · Wilmington, DES/N 32-57165N4184RB&S Air LLC · Palm City, FLBuilt 1968 · S/N 32-40517N4184XM&N Aviation LLC · Carolina Beach, NCBuilt 2001 · S/N 3257200N4185XWjw Transport Inc · Hampshire, ILBuilt 2000 · S/N 3257195N41866Racy Equipment Leasing LLC · Tucson, AZBuilt 2000 · S/N 3257177N41874Tailwinds Leasing LLC · Missoula, MTBuilt 1999 · S/N 4636230N4187HMcalister Aviation LLC · Greenwood, ARBuilt 2000 · S/N 3257196N4187QAggie80 Air LLC · Richmond, TXBuilt 2001 · S/N 3257214
Back to AD 71-13-01 R1