OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648N2682MDavis Philip L · Spring Hill, TNBuilt 1946 · S/N 12-1113N2682TMorrison James S · Bergen, NYBuilt 1971 · S/N 28-7225086N2682ZEmslie Donis A · West Lafayette, OHBuilt 1978 · S/N 265-78N26830Butcher Alden K · Jane Lew, WVBuilt 1978 · S/N AA5A0748N26831Horn Charles R Jr · Avondale, AZBuilt 1978 · S/N AA5A0749N26839Brown Timothy · Plainfield, INBuilt 1978 · S/N AA5A0756N2683ALovett Andre D · Anchorage, AKBuilt 1953 · S/N 18-2189N2683CGrigg Charles G · Pasco, WABuilt 1978 · S/N R18200211N2683MBeach Banners Inc · Jacksonville, FLBuilt 1946 · S/N 12-1114N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082N2683VPeters Robert M · Fremont, INBuilt 1975 · S/N 177RG0655N2683WSabagh Steve B · Maricopa, AZBuilt 1966 · S/N 1002N2683ZAmmlim LLC · Vacaville, CABuilt 1978 · S/N 1227-78N26840White Mary · Thurmont, MDS/N AA5A0757N26845Thornton Charles A · Collinsville, ILS/N AA5A0761N26847Anderson Wayne D · Providence Forge, VAS/N AA5A0762N2684AMckinley I Blake Jr · Spokane Valley, WABuilt 1952 · S/N 18-2190N2684GBlair Daniel S · Perrysburg, OHS/N 546N2684TGallaher Matthew · Anchorage, AKBuilt 1971 · S/N 28-7225087N26850Palm Michael · Middletown, RIBuilt 1978 · S/N AA5A0765N26855Clarke George W · Sierra Vista, AZBuilt 1978 · S/N AA5A0769N26860Robinson Andrew T · South Windsor, CTBuilt 1978 · S/N AA5A0773N26868Musser Alvin M Jr · Memphis, MOBuilt 1941 · S/N 4252N2686AJohnson James L · Greenville, TXBuilt 1953 · S/N 22-1099N2686MCummings Scott Alan · Monitor, WABuilt 1946 · S/N 12-999N2686TGoddard John · Penokee, KSBuilt 1971 · S/N 28-7205083N26872Hughes Tool & Die LLC · Norfolk, VABuilt 1978 · S/N AA5A0777N26874Sale Reported · Sacramento, CASale reported, pending cancellationS/N AA5A0778N26875Yin Steve · Del Mar, CABuilt 1978 · S/N AA5A0779N2687LA R Preston Holdings LLC · Ontario, NYBuilt 1998 · S/N 18280314N2687MWilkes Gary W · Lakeland, FLBuilt 1946 · S/N 12-1117N2687THolley Ronald E · Hastings, MIBuilt 1971 · S/N 28-7205093N2687ZSchaefer Richard T · Marble Falls, TXBuilt 1978 · S/N 365-78N26880Sinclair Ian · Pembroker, NYBuilt 1978 · S/N AA5A0782N26887Patel Ronik M · Pearland, TXS/N AA5A0789N26888Mcguire Eric · Weare, NHBuilt 1979 · S/N AA5A0790N2688ALanham Rex E · Boise, IDBuilt 1953 · S/N 18-2194N2688BScott Fred · Greencastle, INBuilt 1968 · S/N 28-5065N2688VHampel Michael J · Camas, WABuilt 1975 · S/N 177RG0657N26894Moore Altitude LLC · Lake Saint Louis, MOBuilt 1979 · S/N AA5A0795N26896Magnus Air Ct LLC · Manchester, CTBuilt 1978 · S/N AA5A0751N26899Gibson Daniel W · San Marcos, TXBuilt 1979 · S/N AA5A0796N2689AWomack W A · Jackson, LABuilt 1953 · S/N 18-2195N2689MKuehni Steven A · Stanley, WIBuilt 1946 · S/N 12-1200N2689WLocke Timothy S · Fort Irwin, CABuilt 1966 · S/N 1006N268BGHuff Holdings LLC · Ashland, KYBuilt 1976 · S/N 28-7690268N268BHJett Cory L · Floyds Knobs, INS/N 888-76N268CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283018N268CRMaxcy Christopher L · Bozeman, MTBuilt 2010 · S/N 4
Back to AD 81-18-04 R2