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.

N802RCCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 28R-30299N802RGGandt Robert · Port Orange, FLBuilt 2003 · S/N 70215N802RHKnl Associates LLC · Mansfield, OHBuilt 2017 · S/N 74366N802RJBeavers Air LLC · Fort Walton Beach, FLBuilt 2006 · S/N 80002N802RVDimeo Robert · Bedford, NHBuilt 2006 · S/N 80423N802SASpirit Air Inc · Salmon, IDBuilt 1982 · S/N 2107N802SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8107N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524N802WCHrabe Daren L · Tea, SDBuilt 2018 · S/N 82408N802WHMansfield Heliflight · Milton, VTS/N 0802N80300Ryther Jonathan W · Redlands, CAS/N 17266506N80304Matthews David A · Anchor Point, AKBuilt 1975 · S/N 17266510N80307Hughes Fredrick A · Oklahoma City, OKBuilt 1975 · S/N 17266511N8030DSunrise 6500 Inc · Wilmington, DEBuilt 2004 · S/N 22660N8030JKeystone Aircraft Leasing LLC · Selinsgrove, PABuilt 1978 · S/N 61P-0508-211N8030NWilson Mark A · Havana, FLBuilt 1968 · S/N 28-25275N8030WGosse Luke J · Waterloo, IABuilt 1964 · S/N 28-2096N8030YPaden Frank G · Lawrenceburg, KYBuilt 1966 · S/N 30-1139N8031GFletcher Craig B · Willis, TXBuilt 1970 · S/N 177RG0031N8031JCp3 Construction Inc · Los Angeles, CABuilt 1978 · S/N 61P-0509-212N8031POphus Larry N · Big Sandy, MTBuilt 1962 · S/N 24-3278N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097N8031XRegistration Pending · Camas, WARegistration pendingBuilt 2003 · S/N 60565N8031YBresin Sharon M · Kamas, UTS/N 30-1140N8031ZCoppen Walter G · Orange Park, FLS/N P-354N8032Kelly Patrick E · Carson City, NVBuilt 1974 · S/N 1-0020N80322Mt Aviation LLC · Fairbanks, AKS/N 17266518N80326Fly Lugu LLC · Southwick, MABuilt 1975 · S/N 17266520N80327Highland Rim Aviation LLC · Springfield, TNBuilt 1975 · S/N 17266521N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097N8032HWintringham Henry J Jr · Max Meadows, VABuilt 2003 · S/N 6-4186N8032JMchuard LLC · Wilmington, DEBuilt 1978 · S/N 61-0510-129N8032PMorrison Danny G · Louisburg, KSBuilt 1963 · S/N 24-3279N8032YCain Jeffrey J · Denver, COBuilt 1981 · S/N 6N8033Stafy Ronald F · Pottstown, PABuilt 1974 · S/N 1-0021N80331Johnson Shem E · Bonners Ferry, IDS/N 17266525N80332Lamb Joseph M · Conway, ARBuilt 1975 · S/N 17266526N80333Coeytaux Britton Marielle G · St Helena, CABuilt 1975 · S/N 17266527N80335Rawareo LLC · Warsaw, MOBuilt 1975 · S/N 17266529N80336Joyal Alfred N III · Marquette, MIBuilt 1975 · S/N 17266530N80338Maldonado Monell Julio · Carolina, PRBuilt 1976 · S/N 17266532N8033DLevinson Alan J · Delta Junction, AKBuilt 1957 · S/N 22-5558N8033GStoltz Curtis · Winter Haven, FLBuilt 1970 · S/N 177RG0033N8033WRegistration Pending · Burlington, WARegistration pendingBuilt 1965 · S/N 28-2099N80340Tangojuliet Aviation LLC · La Porte, INBuilt 1976 · S/N 17266534N80342Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17266535N80347Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266538N80349Giles Jonathan P · Fountain Inn, SCBuilt 1981 · S/N 32R-8213020N8034DMyers Mark · Clovis, NMBuilt 1957 · S/N 22-5559N8034EHill Matthew E · Abingdon, VABuilt 1975 · S/N AA5B0191
Back to AD 81-18-04 R2