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.

N955JAAero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10501N955JPHassan Sibte · Brooklyn, NYBuilt 2009 · S/N 91416N955LCSewell Michael D DBA · Russellville, ALBuilt 1974 · S/N 17264572N955MATaylor Christopher B · Vacaville, CABuilt 1966 · S/N 3384N955MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1236N955PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264573N955RVBlessinger Christopher R · Lenore, IDBuilt 2006 · S/N 2341N955SEmge Douglas W · Albertville, ALBuilt 1979 · S/N 287990385N955SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881875N955SKConcho Aviation LLC · Sterling City, TXBuilt 2005 · S/N 3969N955SMCustom Concrete & Building LLC · Pleasantville, TNBuilt 2004 · S/N 21087CN955SPBarto Jerrel C · Kula, HIBuilt 1999 · S/N 172S8155N955TMaynard Robert R · Inglewood, CARegistration revokedBuilt 1960 · S/N TD-401N955TTWhelan Carol · Suffield, CTBuilt 1969 · S/N AA1-0156N95606Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285936N9560JAdams Carl J · Conroe, TXS/N 28-3691N9560MPontarolo Michael A Trustee · Pacific Grove, CABuilt 1966 · S/N 670137N9560PJetran LLC · Horseshoe Bay, TXBuilt 1974 · S/N 25-7405674N9560SMoore Justin W · Hollywood Park, TXBuilt 1998 · S/N 17280495N9560UBletsis Richard · Kokomo, INBuilt 1977 · S/N AA1C0057N9560VRegistration Pending · Big Spring, TXRegistration pendingBuilt 1974 · S/N 17264362N9560WGeneral Aviation LLC · Henderson, NVBuilt 1998 · S/N 17280496N95615Li LLC · Seattle, WABuilt 1984 · S/N 15285938N9561CRak Flight Squad LLC · Bronx, NYBuilt 1978 · S/N 28-7816493N9561DHughey Randal P · Muskegon, MIBuilt 1958 · S/N 22-6478N9561FBarrows Carl A · Lisle, NYBuilt 1970 · S/N 200450N9561JScarlet Aviation LLC · Jonestown, PAS/N 28-3692N9561LWalter Terrance A · Pinckney, MIBuilt 1974 · S/N AA5-0661N9561MAck & Co LLC · East Helena, MTBuilt 1967 · S/N 670106N9561VAbove And Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280497N95626Smith Charles · Hays, NCBuilt 1984 · S/N 15285943N9562BCharleston Flying Club LLC · Charleston, SCBuilt 1981 · S/N 172RG0882N9562HL & W Aircraft Investments LLC · Homestead, FLBuilt 1975 · S/N 17266230N9562JPosnett William L III · Lexington Park, MDBuilt 1966 · S/N 28-3697N9562MPhillips Gary C · Midland, MIBuilt 1966 · S/N 670139N9562PAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280499N9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORBuilt 1998 · S/N 17280501N9562SVon Bevern Brian J · Overland Park, KSBuilt 1966 · S/N 84N9562UFoote Peter S · Lockport, NYBuilt 1977 · S/N AA1C0061N9562VWinged Winds LLC · Douglassville, PABuilt 1974 · S/N 17264364N9562WHub City Aviation Academy LLC · Lubbock, TXBuilt 1967 · S/N 28-22999N9563Marzich Frank M · Rockford, ILBuilt 1971 · S/N 076N95639Barbee Donald · Columbus, OHS/N 15285949N9563AChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280502N9563FClunie David A · Bangor, PABuilt 1971 · S/N 200447N9563LFite James · Victorville, CABuilt 1974 · S/N AA5-0563N9563PTodd Doug A · De Witt, IAS/N 18-7609155N9563TStone Michael S · Chamois, MOBuilt 1978 · S/N 38-78A0132N9563UCrawford Aviation LLC · Richmond, VABuilt 1977 · S/N AA1C0062N9563WEastside Development Co Inc · Winfield, KSBuilt 1967 · S/N 28-23000
Back to AD 81-18-04 R2