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.

N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299N559ESeitan Eduard · Chicago, ILS/N 28-3248N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400N559JPNelson Scott E · Whispering Pines, NCBuilt 1978 · S/N 32R-7885276N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286N559MANorwood Kenneth Trustee · Rogers, ARBuilt 2000 · S/N 3246159N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170N559PTracy Theodore W · West Chester, OHBuilt 2007 · S/N 317N559PDCrocker Donald E · Eagle, IDBuilt 2015 · S/N 91817N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096N559RKRegistration Pending · Sheridan, WYRegistration pendingBuilt 1999 · S/N 0559N559RVBrady Norman M · Port Orange, FLBuilt 2009 · S/N 90978N559SGQualitair LLC Trustee · MichelstadtBuilt 1976 · S/N 384N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410N559TJHangar 22 LLC · Watkinsville, GABuilt 2000 · S/N 18280852N559WKleiss Norman J · Cloverdale, INBuilt 2006 · S/N 0001N55ADSchrage Rodney L · Steamboat Springs, COBuilt 1977 · S/N 1006N55AFRegistration Pending · Terre Haute, INRegistration pendingS/N 32-864N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804N55AHHancock James T · South Saint Paul, MNBuilt 1978 · S/N 5555N55AJJudge Andrew L · Pinecrest, FLBuilt 1998 · S/N DMO 413N55AMAdams Floyd R · Sebring, FLBuilt 1966 · S/N 362N55ATAugust Aero LLC · Kalispell, MTS/N 001N55AUWallner Chris R · Petaluma, CABuilt 2003 · S/N 60537N55AVFood Service Installations Inc · Vancouver, WAS/N 41889N55BCMcconnell Bert J · Hudson, OHBuilt 2003 · S/N 60360N55CRUltrapure Air LLC · Setauket, NYBuilt 1997 · S/N 392N55CYBonneville Aero Works LLC · Greenville, SCBuilt 1961 · S/N 24-2674N55DACircle L J Aviation Inc · Plant City, FLBuilt 1951 · S/N C1-0319N55DHAcmed Consulting LLC · Bradford, RIBuilt 1997 · S/N 24-3414N55DPMagaw David N · Sacramento, CABuilt 1974 · S/N DP-3N55DVDevine William L Jr · Maple Falls, WABuilt 1948 · S/N 14-192N55DYBrown Carl A · Las Cruces, NMBuilt 1992 · S/N 194N55DZHuey Christopher D · Mesa, AZS/N 9472004N55EDonnelly Mitch L · Mcloud, OKS/N BEA-1N55EKMengel David M · Monticello, INS/N 1568N55ELLynn Edward Wayne · Vancouver, WABuilt 2019 · S/N 25237N55EMIxi LLC · West Bloomfield, MIBuilt 1974 · S/N 28-7415328N55EWHanratty Brian James · Pismo Beach, CABuilt 1966 · S/N TD-681N55FFSiedschlag Paul C · Granbury, TXBuilt 1978 · S/N 24-0672N55GASaathoff Michael A · Stockton, MOS/N 541N55GBRivers Paul E · Shannon, ILBuilt 1979 · S/N 212056N55GGAll Attitude Aviation Inc · Edgewater, FLBuilt 1985 · S/N 1030N55GLBates John W · Westerly, RIBuilt 2016 · S/N GL-003N55GR55 Golf Romeo LLC · North Myrtle Beach, SCBuilt 1989 · S/N 1124N55GTTurner William Hugh Vi · Belmont, CABuilt 1979 · S/N 5N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HBStefanick Richard L · Morgantown, WVBuilt 1972 · S/N MB001N55HNNaylor John H · Conway, ARS/N ONEN55HQHerndon Colton R · Smithville, MOBuilt 1965 · S/N 743
Back to AD 81-18-04 R2