AD 81-18-04 R2

Registered aircraft · 81,733

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-18-04-R2')
    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-18-04-R2')
  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.

N831BBVentec LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1999 · S/N 3246135N831BFHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 28-3502N831BRAir Future Airways Corp · Miami, FLBuilt 1998 · S/N 172S8044N831DBN831db LLC · Canby, ORBuilt 2010 · S/N 40831N831EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12842N831GBDievendorf Gerry T · Columbia, SCS/N 284N831GRGrahn James A · Las Vegas, NVBuilt 1988 · S/N 831N831JNErlanger Joshua · Jupiter, FLBuilt 2023 · S/N 18283247N831JRRegistration Pending · High Springs, FLRegistration pendingBuilt 1959 · S/N 24-585N831KTPilot Network Flyers LLC · Bastrop, TXBuilt 1974 · S/N M-1548N831KXRkm Leasing LLC · Greenwich, CTBuilt 2011 · S/N 172S11107N831LBWedekemper Steven E · Brighton, MIBuilt 2007 · S/N 515-2007N831MAState Of Wisconsin · Madison, WIBuilt 2001 · S/N 172S9003N831MNSallee William T · Sylvania, OHBuilt 2019 · S/N 91445N831NDCirrus Aviation Inc · Sarasota, FLBuilt 1978 · S/N 28-7816351N831NQEslinger Carl W · Chouteau, OKBuilt 2018 · S/N 03N831PMAvier LLC · Beverly, MABuilt 2024 · S/N 2881735N831RHHanson Paul D · Evansville, INBuilt 1997 · S/N 789-97N831SSmith James A Trustee · Cheyenne, WYBuilt 2016 · S/N 41341N831SHHutchison Eugene W · Armagh, PABuilt 2005 · S/N 3793N831TSWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 28-7415485N831VZMelbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276416N83208Rothrock Cara J · Streator, ILS/N 28-8116124N8320AMendez Leonel Jr · Corpus Christi, TXBuilt 1995 · S/N 2510N8320CRiffle Bruce H · Chesterton, INBuilt 1975 · S/N 28-7690115N8320VThurman Randall N · Mcminnville, ORBuilt 1966 · S/N 399N8320WOracle Aviation LLC · Omaha, NEBuilt 1965 · S/N 28-2495N8320YKling Aviation Inc · Friendswood, TXBuilt 1967 · S/N 30-1460N83210Chapman Jeremy · Niagara Falls, NYBuilt 1980 · S/N 32-8106035N83212Salty Flights LLC · Labelle, FLBuilt 1980 · S/N 32R-8113034N83213P-R Aircraft LLC · Snellville, GABuilt 1981 · S/N 32R-8113035N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147N8321HJust Plane Fellas LLC · Omro, WIBuilt 1980 · S/N 28-8116125N8321LArevalo Gilbert Jr · Loranger, LABuilt 1980 · S/N 28-8190136N8321MFox Two LLC · Camino, CABuilt 1980 · S/N 28-8190137N8321PSmoketown Helicopters LLC · Smoketown, PABuilt 1995 · S/N 2538N8321RThompson Grady R · Athens, ALBuilt 1966 · S/N 2822192N8321TRobinson Denise · Middletown, CTBuilt 1980 · S/N 28-8190140N8321WWeighman David R · Battle Creek, MIBuilt 1965 · S/N 28-2496N8322EHorton Ernest J III · Galveston, TXBuilt 1959 · S/N 1500N8322SAtp Aircraft 4 LLC · Wilmington, DEBuilt 1980 · S/N 44-8195014N8322V11 Point Aviation LLC · Alton, MOBuilt 1966 · S/N 65N8322WLickteig Eric Kirk Trustee · Ellensburg, WABuilt 1965 · S/N 28-2499N8322YDayhoff Miller Alice J · Springfield, OHBuilt 1967 · S/N 30-1463N83231Padilla Rafael R · Monee, ILBuilt 1980 · S/N 28-8111047N8323AWisconsin Aviation Inc · Watertown, WIBuilt 1981 · S/N 28-8216019N8323BMidcoast Helicopter Services Inc · La Ward, TXBuilt 1995 · S/N 2535N8323FDavis William · Texarkana, TXBuilt 2000 · S/N 18280879N8323VToczek Keith E · Yankton, SDS/N 55N8323WConcord Aviation Services LLC · Concord, NHBuilt 1965 · S/N 28-2500
Back to AD 81-18-04 R2