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.

N569FLN7396w LLC · Coeymans Hollow, NYS/N 28-7125413N569MKindred Daniel P · Jacksonville, ILFirst renewal noticeS/N 20-0009N569MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.314N569NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S11004N569NEMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 15282580N569RVRicketts Michael D · Weirsdale, FLBuilt 2010 · S/N 91519N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494N569TJAnderson Thomas C · Poplar Grove, ILBuilt 2013 · S/N 259RN569TSBig South Fork Aero Inc · Huntsville, TNBuilt 1993 · S/N 722-93N569WHGp Cub Air LLC · Sioux Rapids, IABuilt 1965 · S/N 18-8271N56ABBezanson Adam M · Fremont, NHBuilt 2024 · S/N 41687N56AMPeavy Michael J · Chico, CABuilt 1976 · S/N 957N56BEBirds Eye View Inc · Middletown, RIBuilt 2017 · S/N 2476N56BGGuernsey Gibson R · Belen, NMBuilt 1980 · S/N 140N56BSHansen Nick K · Litchfield Park, AZBuilt 1987 · S/N 1N56BVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N AA5A0719N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297N56CEWave Shack Acquisitions LLC · Lewes, DEBuilt 1991 · S/N LARES 0001N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003N56CVVaughn Geoffrey · Brunswick, GABuilt 1976 · S/N 14017N56CWLaurel Aviation Inc · Decatur, ILBuilt 2024 · S/N 18283256N56DBBerger Dale · Bay Village, OHBuilt 2002 · S/N 1128N56DDMeier Perry S · Conroe, TXBuilt 1976 · S/N D2DN56DFThorpe Arthur N Jr · Salisbury, MDBuilt 1980 · S/N 44-8107030N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239N56DWReed John S · Wasilla, AKS/N 18-7709159N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661N56EKQuailair LLC Trustee · MichelstadtS/N 2890145N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728N56ERGsell Bruce Ward · Southampton, NJBuilt 1979 · S/N AA5B-1094N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348N56FDDefibaugh Fred M · Chino Alley, AZS/N 3535N56FJRocky Mountain Construction LLC · Klamath Falls, ORBuilt 2023 · S/N AL-367N56GBCalhoun Keith A · Springville, TNBuilt 1997 · S/N 56N56GH45g Aviation Services LLC · Fenton, MIBuilt 2022 · S/N 60523N56GTDonaldson Timothy A · Oklahoma City, OKBuilt 1976 · S/N AA5B-0344N56GUIdagus N56gu LLC · Miami, FLBuilt 2022 · S/N 18283208N56HCFaire Ken · Mojave Valley, AZBuilt 1976 · S/N 2N56HJRobinson Douglas J · Dayton, NVBuilt 1997 · S/N 24348N56HRStrachan Annmarie C · Overgaard, AZBuilt 2002 · S/N 81408N56HYCipolli Robert J · Montgomery, MABuilt 2003 · S/N 2222N56JDDignan Charles N · Telluride, COBuilt 1976 · S/N 1N56JFWadsworth Chad · Lake Havasu City, AZBuilt 1997 · S/N 53N56JSPoppy Wayne J · New London, WIFirst renewal noticeS/N 1001N56JUSurfield Ronald W · Leonardtown, MDS/N 22159N56KCCrawford William K · Ovilla, TXBuilt 2004 · S/N T018N56LAGroat Stanley G · Austin, ARBuilt 1979 · S/N 973N56LBArlington Flight Services Inc · Arlington, WABuilt 1959 · S/N TD-279N56LGLake Skippers LLC · Park Rapids, MNBuilt 1976 · S/N 18-7609051
Back to AD 81-18-04 R2