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.

N8530DCurcio Steve J · Oak Creek, WIBuilt 1957 · S/N 22-5758N8530NGood Curvin M · Memphis, MOBuilt 1969 · S/N 28-11329N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691N8531NCaltrider Joseph S · Williamstown, WVBuilt 1969 · S/N 28-11330N8532NNiederberger Edgar C · Idaho Falls, IDBuilt 1969 · S/N 28-11331N8532WSorby Kyle · Fort Ransom, NDBuilt 1963 · S/N 28-10033N85348Passeno Mark A · Cheboygan, MIS/N 7AC-4088N8534CSalter Christopher D · Elberta, ALBuilt 1953 · S/N 22-1239N8534NVilar Mitch · Brookfield, WIBuilt 1969 · S/N 28-11333N8535NJeffrey Robert Hudson · Bakersfield, CAS/N 28-11334N8535XMachen36 LLC · Dover, DEBuilt 2018 · S/N 1224N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768N8536NMcmath Robert · Seeley Lake, MTS/N 28-11335N8536WFeather Inc · Clarksdale, MSBuilt 1963 · S/N 28-10037N8536XTrask John D · Portsmouth, VABuilt 1984 · S/N 1096N8536YEastern Flight Services Inc · Ronkonkoma, NYBuilt 1984 · S/N 0438N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73N8537MRegistered aircraftBuilt 1963 · S/N TD-534N8537WGone With The Wind LLC · Sturgis, SDBuilt 1963 · S/N 28-10038N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769N8538JHarrison Gene R · Pendleton, ORS/N BROSE-0001N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770N8539NMcbride Ivan L · Toddville, IABuilt 1969 · S/N 28-11338N8539WMccarthy Royal B · Eureka, CABuilt 1963 · S/N 28-10040N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626N853AAAb Prop Plane I LLC · Metairie, LABuilt 2026 · S/N 28010044N853AKKase Gayle L · Wasilla, AKBuilt 2017 · S/N 6901N853CEWilford Boone · Cotter, ARBuilt 2012 · S/N 802RN853CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281853N853LCCox Leon F · Ruffin, NCBuilt 2013 · S/N 70299N853MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 1206N853NBuffaloe Thomas N · Mancos, COBuilt 1946 · S/N 91N853NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881369N853PADk Skyhawk LLC · Fulshear, TXBuilt 2019 · S/N 172S12286N853RSOlson Helicopters LLC · Corpus Christi, TXS/N 3807N853RVPlumley James Christopher · Travelers Rest, SCBuilt 2007 · S/N 90853N853SPPavilon Clemens J · Bolingbrook, ILS/N 002N853VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1966 · S/N 32-630N8540YCli Aerospace LLC · Appleton, WIS/N 30-1568N8541CHulsey Johnathan James · Wasilla, AKBuilt 1997 · S/N 999N8541EFlying Services Inc · Wilmington, DEBuilt 1984 · S/N 0442N8541NSunrise Aviation LLC · Sumrall, MSS/N 28-11340N8542NSchwechten Kevin · New Waverly, TXBuilt 1969 · S/N 28-11341N8542WChenevert Kenneth F · Seguin, TXBuilt 1963 · S/N 28-10043N8542YAviation Training Solutions LLC · Hilo, HIBuilt 1967 · S/N 30-1598N8543DHuntwork Dayna · Boise, IDBuilt 1957 · S/N 22-5774N8543EAce Aircraft Leasing Inc · Nazareth, PABuilt 1976 · S/N 28-7625140N8544CNixon H M · Wayne, NJBuilt 1953 · S/N 22-1256
Back to AD 81-18-04 R2