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.

N555DYCaptain'S Quarters Marina & Storage Inc · Johnson Lake, NEBuilt 1966 · S/N 670055N555EDPoteet-Schwartz Kim L · Albuquerque, NMS/N 24-0684N555EEKielich Darryl C · Knights Landing, CABuilt 1968 · S/N 28-24888N555ERCherokee Rose Mammography LLC · Macon, GABuilt 1997 · S/N 18280068N555FBMunson Seth · Phoenix, AZBuilt 2007 · S/N 70021N555FCRegistered aircraftBuilt 1981 · S/N R18201707N555FJAir Kanga LLC · Wilmington, DEBuilt 2008 · S/N 80807N555FLD&J Aviation LLC · Apopka, FLBuilt 1971 · S/N 28-7125394N555FNFlying Neutrons LLC · Lebanon, OHBuilt 2001 · S/N 17280999N555FPRotorpro LLC · Sevierville, TNBuilt 2001 · S/N 1012N555GBGreen Chad W · Wasilla, AKS/N 18-6379N555GCSasakwa LLC · Pittsfield, MABuilt 1967 · S/N 670508N555GMDavis Scott · Morse, TXBuilt 1968 · S/N 28-11010N555HAYasko Gary R · Gallipolis, OHBuilt 1978 · S/N 28-7916125N555HEDetert Bradley · Valparaiso, INBuilt 1999 · S/N 848-99N555HFChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 4496176N555HYMikes Flight Service LLC · Pine Bluff, ARS/N 2217N555JBPerkins Robert Tahte · Anchorage, AKBuilt 1959 · S/N 18-7102N555JKTenhoopen Thomas W · Livonia, MIBuilt 1973 · S/N 282-74N555JLSearles Warren Jr F · Pittstown, NJBuilt 1978 · S/N 32-7840144N555JMFingerlakes Area Pilots Inc · Seneca Falls, NYBuilt 1979 · S/N 28-7916412N555KAKimmel Frank S III · Greenwood, MSBuilt 1967 · S/N TD-707N555KGLegacy Performance Inc · Wilmington, DEBuilt 2012 · S/N 81007N555KLShemenski Aaron J · Tiverton, RIBuilt 1974 · S/N 28R-7535044N555LASouth Latitude Aviation Service LLC · Humble, TXBuilt 1976 · S/N 17268207N555LBDeuling Jarrett R · Lexington, KYBuilt 2021 · S/N 01N555MAAlexander Mary B · Gig Harbor, WAS/N 2099N555MJMarker Michael M Jr · Los Lunas, NMBuilt 1994 · S/N SH-3118N555MMRelativity Inc · Lakeway, TXBuilt 2022 · S/N 18283177N555MPMiller Gregory Trustee · Anchorage, AKBuilt 2025 · S/N 3305N555NAWe Warrior Three LLC · Paragould, ARBuilt 1974 · S/N 28-7415500N555NSN8241r LLC · Leawood, KSBuilt 1969 · S/N 30-1790N555PAPyle Dana C · Naples, FLBuilt 1972 · S/N 28-7225476N555PBM5 LLC · Kit Carson, COBuilt 1973 · S/N 287305016N555PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842092N555PXWindsock Holdings LLC · Amarillo, TXBuilt 1982 · S/N 60-8265028N555QFColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1992 · S/N 2890173N555QRCarry On Leasing Inc · Wilmington, DEBuilt 2003 · S/N 10140N555RMCulwell Lewis D · Helena, MTBuilt 1988 · S/N 397N555RSR&M Aviation LLC · Austell, GABuilt 1963 · S/N M-412N555RWSkyrunner Charters LLC · Colleyville, TXBuilt 2025 · S/N 1373N555SLHuffman Jacob M III · Burleson, TXBuilt 1973 · S/N 17262755N555SMWalla Walla University · College Place, WABuilt 1973 · S/N 17261805N555STSweeney Steven · Avon, COBuilt 1979 · S/N 15283493N555TWMccabe Robert J Trustee · Cherry Hill, NJBuilt 1973 · S/N 28-7305578N555UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3550N555UMBoretide Aviation LLC · Anchorage, AKBuilt 1971 · S/N 28-7105078N555UPAtlantic Coast Helicopter Ltd · Ronkonkoma, NYBuilt 1998 · S/N 2792N555VCBassetti Cody J · Paso Robles, CABuilt 1969 · S/N 28-26049N555VKChet W Fortney LLC · Helena, MTBuilt 1979 · S/N R18201207
Back to AD 81-18-04 R2