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.

N9338RMeshinsky Jeffrey · Alpine, CABuilt 1978 · S/N R18200693N9338SGentilin Glen R · Camino, CABuilt 1975 · S/N M-1643N9338VDheedene Nicholas · San Mateo, CABuilt 1969 · S/N 700004N93397Jet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15285479N9339JTruesdell Michael L · Tonopah, NVS/N 28-3436N9339LLumbra Valerie A · Lehigh Acres, FLBuilt 1971 · S/N AA1A-0039N9339NKadee Transportation LLC · Bucyrus, KSBuilt 2006 · S/N 90761N9339VTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 700005N933AZN933az LLC · Miami, FLBuilt 1980 · S/N 15284626N933BCPathak Rahul · Mercer Island, WABuilt 2024 · S/N 1219-2024N933BKKreul Robert W · Waconia, MNBuilt 1971 · S/N 28-7225113N933BPMarr Steven K · Saint Charles, MOS/N 1585N933CC27 Latitude LLC DBA · West Palm Beach, FLBuilt 1979 · S/N 28-7990503N933CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282399N933CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283333N933DSDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYBuilt 2003 · S/N 40.327N933GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881224N933GYDemaria Steven M · Dacula, GAS/N 839N933JMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 44-8207009N933LTAerosim Flight Academy · Sanford, FLBuilt 2018 · S/N 4496421N933SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280526N933SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881873N933TEBcaz Holdings LLC · Wilmington, DEBuilt 2002 · S/N 10212N933XAndrews Richard S III · Guilford, CTBuilt 2005 · S/N 60515N93407Board Of Trustees DBA · Murphysboro, ILFirst renewal noticeBuilt 1981 · S/N 15285481N9340JLovelace Mario · Coral Springs, FLBuilt 1966 · S/N 28-3438N9340MWeidner Mark · Cincinnati, OHBuilt 1966 · S/N 1272N9340N9340n LLC · Broken Arrow, OKBuilt 1969 · S/N 28R-35041N9340SGarbade Richard L · Martinez, GAS/N MC-349N9341CMerlin Aviation LLC · South Saint Paul, MNBuilt 1978 · S/N 28-7890399N9341HAndreas Neil A · Yakima, WABuilt 1975 · S/N 17266099N9341MGabel Mark E · Oxnard, CABuilt 1966 · S/N 1273N9341SSantos Eric G · West Oneonta, NYBuilt 1975 · S/N M-1644N9341TWilliams Norman L · Ennis, TXBuilt 1978 · S/N 38-78A0048N9341VAvalle Oscar A · Chicago, ILBuilt 1969 · S/N 700006N9341WSleigh Jonathan B · Upland, CAS/N 28-11027N9342FChurchill David J · Bear, DEBuilt 1998 · S/N 18280105N9342HGutierrez Ricardo · Downey, CABuilt 1975 · S/N 17266100N9342JDeschepper Sandra K · Independence, MOBuilt 1966 · S/N 28-3440N9342LSeaton Robert D · Seguin, TXBuilt 1971 · S/N AA1A-0042N9342RCampbell Gene H · Baytown, TXBuilt 1978 · S/N 17702752N9342TChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11153N9342VClute Charles J · New Smyrna Beach, FLBuilt 1969 · S/N 700005N9342WSmith Bradley W · St George, UTBuilt 1968 · S/N 28-11028N93434Silver Express Co DBA · Miami, FLBuilt 1982 · S/N 15285486N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128N9343LC&L Aviation Ltd · Maysville, KYS/N AA1A-0043N9343MStateline Trucking Inc · Fruita, COBuilt 1966 · S/N 1275N9343VFundora Joel A · Altamonte Springs, FLBuilt 1969 · S/N 700007N93444Sullivan Wayne · Rockport, TXS/N 15285491
Back to AD 81-18-04 R2