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.

N898NDKleyn Transportation LLC · Grand Rapids, MIBuilt 2007 · S/N 40054N898PTitus Aviation LLC · Fresno, CAS/N 28-7515403N898RVAcree Joseph R · Calhoun, GABuilt 2012 · S/N 40030N898SCBmsb Aviation LLC · Bogart, GABuilt 2007 · S/N 80533N898SEFrieling Judson D · Houston, TXBuilt 2015 · S/N 41153N898SYGordon Brett · Ewa Beach, HIBuilt 1988 · S/N 2020N898TTMayes Kevin A · Rockwall, TXBuilt 2014 · S/N 83363N898WRegistered aircraftBuilt 2007 · S/N 80792N8990FDeon Esterhuizen Inc · Clearwater, FLBuilt 1974 · S/N 640313N8990JStites Charles Harold · Chapel Hill, NCBuilt 1966 · S/N 28-3014N8991CSpicer Luke J · Seneca, SCS/N 22-1564N8991JCavoto Allyn E III · Adrian, PABuilt 1965 · S/N 28-3015N8991LSky Clock LLC · Mesa, AZBuilt 1974 · S/N AA1B-0441N8991YWaldemar Mojica · Arecibo, PRBuilt 1974 · S/N 18-7409133N8992JMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1965 · S/N 28-3016N8992RBcm Consulting Inc · Wilmington, DEBuilt 1992 · S/N 20605N8992VFreeze Otis C · Frankston, TXBuilt 1974 · S/N 17264347N8992WKelk Investment Management LLC · Lake Tomahawk, WIBuilt 1965 · S/N 28-10572N89933Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282920N89934Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282921N8993DKey James M · Hermiston, ORBuilt 1958 · S/N 18-6397N8993JHealy Law Offices Pc · Tyler, TXBuilt 1965 · S/N 28-3017N8993RMiller Scott A · Piney Flats, TNBuilt 1960 · S/N 7GCB-22N8993VBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 17264348N8993YAirglas Inc · Anchorage, AKBuilt 1974 · S/N 18-7409135N8994JBatham Carin C · Yuba City, CABuilt 1965 · S/N 28-3018N8994RT & H Aviation LLC · Rector, ARS/N 45N8994WLong Evertt W · Wichita, KSFirst renewal noticeBuilt 1964 · S/N 28-10575N8995DGraham William Franklin III · Port Alsworth, AKBuilt 1958 · S/N 18-6403N8995JBloomquist Eric R · Phoenix, AZBuilt 1965 · S/N 28-3019N8995WBlair Maksim J · Pensacola, FLBuilt 1964 · S/N 28-10576N89963Wardall Wesley David · Ione, CABuilt 1978 · S/N 15282931N8996EHooligan Air LLC · Ponce Inlet, FLBuilt 1976 · S/N 28-7690217N8996VBaumgartner Scot W · Colby, WIBuilt 1974 · S/N 17264351N8996WVan Seghbroeck Jeffrey A · Zion Crossroads, VABuilt 1965 · S/N 28-10577N8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 18-7409138N8997DFinley Peter T · Bismarck, NDBuilt 1958 · S/N 18-6405N8997JKakuska Michael · Madison, WIBuilt 1965 · S/N 28-3021N8997LBaldwin Rodger D · Decatur, ILBuilt 1974 · S/N AA1B-0447N8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEBuilt 1974 · S/N 17264352N8997WDockers Elite Aviation LLC · Towanda, KSBuilt 1964 · S/N 28-10579N89980Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282937N8998EGeorgetson Michael J · Sayre, PABuilt 1976 · S/N 28-7690219N8998JObrien Robert · Warrens, WIBuilt 1966 · S/N 28-3022N89994Lon Aviation LLC · Aspen, COS/N 18-8510N8999DPadgett Benjamin C · Anchorage, AKBuilt 1958 · S/N 18-6407N8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1960 · S/N 7GCB-35N8999WEagle Air LLC · Red Bud, ILBuilt 1966 · S/N 28-10817N899AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2016 · S/N 172S11767N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353
Back to AD 81-18-04 R2