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.

N95CWPirani Aaron M · Jacksonville, FLS/N 720N95DHHooker Douglas L · Spring Branch, TXBuilt 2017 · S/N JA1607096N95DJSanders Aviation Inc · Jasper, ALBuilt 1963 · S/N TD-556N95DLOwen Jayson S · Tampa, FLBuilt 1960 · S/N TD-418N95DRRoss Dan G · Newcastle, CABuilt 2010 · S/N 82434N95EDHaven Steven D Jr · Capac, MIBuilt 1996 · S/N 1N95EGNelson Gregory E · Austin, TXS/N 636-320-381FBN95EZE Z Flight LLC · Gainesville, TXBuilt 2025 · S/N 3453N95FDLowrey Jonathan S · Jasper, INBuilt 1990 · S/N 785N95FHFlying Hawkes LLC · Hamilton, MTBuilt 2019 · S/N 082N95FSN95fs Ltd · Chicago, ILBuilt 1969 · S/N 30-1786N95GWSkypirate Aviation LLC · Staunton, VABuilt 1995 · S/N 21373N95HCCrosswell Joe · Springtown, TXBuilt 2016 · S/N 1210N95HDGreffenius Brian J · Covington, LABuilt 1995 · S/N 1255N95HFEddings Samuel David · Camino, CABuilt 1973 · S/N 28R7335311N95HJSkyview Aviation LLC · Benton, KYBuilt 1965 · S/N TD-615N95HUJe Consulting LLC · Geneseo, ILBuilt 2026 · S/N 3470N95HYMcmillan Peter · San Francisco, CABuilt 2007 · S/N 2414N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015N95JJHorrigan Patrick B · Shoreview, MNBuilt 2010 · S/N 90216N95JLZhang Weiyu · Madison, WIBuilt 2001 · S/N 24199N95JPKeller Justin Allen · Youngstown, FLBuilt 1973 · S/N 28-7305429N95JVSarli Adrian Christopher · Jackson, TNBuilt 1982 · S/N 95N95KBFront Range Heli Inc · Erie, COBuilt 2014 · S/N 2354N95KKGrimes Chris · Hudson, NYBuilt 1966 · S/N TD-649N95KPPainter Kenneth Lee · Luray, VABuilt 1973 · S/N 119-73N95KRAlta Aviation LLC · Granbury, TXBuilt 2020 · S/N 091N95LJNordin James K · Conroe, TXBuilt 1996 · S/N 001N95MCMarten David H · Cheney, KSS/N MCCANN-0001N95MMManley Marvin W · Camp Verde, AZBuilt 1998 · S/N 60035N95NHOberlander Justin D · Colton, ORBuilt 1974 · S/N 105-74N95PBExtreme Air LLC · Santa Barbara, CABuilt 2024 · S/N 1213-2024N95PGAviation Sensation LLC · Clearwater, FLBuilt 1974 · S/N 28R-7535026N95QLoftis Philip D · Buckhannon, WVBuilt 1975 · S/N 28-7515408N95RSpence Justin A · Memphis, TNFirst renewal noticeBuilt 1967 · S/N OAS-1N95RWColberg Stefan D · North Bend, ORS/N I-AN95SHReady Aim Flyer LLC · New Castle, DEBuilt 1957 · S/N TD-21N95SWMayer Cynthia Lynn · Ponce Inlet, FLBuilt 1978 · S/N 38-78A0107N95TRegistered aircraftBuilt 1987 · S/N 3213003N95TKTalos Aviation Group LLC · Blackstone, VABuilt 1970 · S/N 27-4555N95TPFederal Aerial Applicators LLC · Wilmington, DEBuilt 2006 · S/N 0001N95TSSkywest Leasing Inc · St George, UTBuilt 1997 · S/N 2843103N95VTChase Michael D · North Hero, VTBuilt 2017 · S/N 40644N95WPPercival Wilhelm F · Las Vegas, NVBuilt 1987 · S/N 1995LN95WTDs Flight Services LLC · Battle Ground, WABuilt 1966 · S/N TD-677N95WYBoring Alice Aviation LLC · Talkeetna, AKBuilt 2014 · S/N 3203N95YWhite Tavis · Huntsville, ALBuilt 1964 · S/N TD-604N95ZMVanlandingham Russell · Salem, ORBuilt 2005 · S/N 5824N96009Loera Arnold · Dillingham, AKBuilt 1990 · S/N 1124N9600JCox Grant L · Moses Lake, WABuilt 1989 · S/N 1118
Back to AD 81-18-04 R2