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.

N6294TGreater Flint Pilots Association · Flushing, MIBuilt 1983 · S/N R18201962N6294ULamontagne Brian D · Wyandotte, MIBuilt 1962 · S/N 2133N6294VColomello Charles P · Tillson, NYBuilt 1965 · S/N 661N62953Dodge Inc · Wilmington, DEBuilt 1981 · S/N 17275367N62954Big Bend Community College · Moses Lake, WABuilt 1982 · S/N M-2355N6295DCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272700N6295LGordon Fredrick · Brooksville, MSBuilt 1972 · S/N AA1B-0095N6295URawareo LLC · Warsaw, MOS/N 2134N6295WJ Delgado Aviation LLC · Tulsa, OKBuilt 1964 · S/N 28-20340N62960Fossen Kenneth J · Omaha, NEBuilt 1981 · S/N 17275368N62968Stanley Farms · Grygla, MNBuilt 1972 · S/N 373-72N62969Ls Aviation LLC · Searcy, ARBuilt 1958 · S/N 23-1392N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185N6296LHansen Roy J · Pacific City, ORBuilt 1973 · S/N AA1B-0096N6296NBurg Clinton A · Creswell, ORBuilt 1957 · S/N 18-5696N6296WBarthell Frederick · Sun City West, AZS/N 28-20341N62975Quintessence World LLC · League City, TXBuilt 1972 · S/N 861-72N62977Borgerding Richard · Piqua, OHBuilt 1972 · S/N 855-72N62979Cummings Roy E · Fort Scott, KSBuilt 1972 · S/N 36-72N6297JYale Aviation Inc · New Haven, CTBuilt 1976 · S/N 28-7690394N6297UBeasley Curtis L · Kennewick, WABuilt 1962 · S/N 2136N6297WDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1964 · S/N 28-20342N62982Peterson Derek R · Kenmare, NDBuilt 1972 · S/N 361-72N62984Hopkins George · Chippewa Falls, WIBuilt 1972 · S/N 363-72N6298JPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 28R-7635334N6298MLapham John R · Palm Beach Gardens, FLBuilt 1980 · S/N 15284660N6298PN6298p Inc · Okeechobee, FLBuilt 1959 · S/N 24-1278N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704N6299UKeelin Freddie B · Sagle, IDBuilt 1975 · S/N AA5-0782N629AHSuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9301N629AKCloward Marc D · Cordova, AKBuilt 1951 · S/N 18-122N629APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 266-78N629BWagner Nathan D · Dane, WIBuilt 1997 · S/N 5108N629BCVolar V LLC · Edmond, OKBuilt 2013 · S/N 172S11277N629CGC-4 Aviation LLC · Fruitland Park, FLFirst renewal noticeBuilt 1981 · S/N 32-8106094N629CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282268N629EMMelendez Carlos M · Saint Petersburg, FLBuilt 2018 · S/N 001N629EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2021 · S/N 172S12750N629ESKorenek Michael A · Houston, TXBuilt 2002 · S/N 18281163N629FCDoherty Paul A · Van Buren, ARBuilt 1979 · S/N 32-7940182N629FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842132N629GKTumenas Daniel E · Girdwood, AKS/N 001N629GWPage Cathleen A · Tucson, AZBuilt 1994 · S/N 23072N629HBBattle Creek Powersports LLC · Jasper, TNBuilt 1958 · S/N 23-1527N629JCCzachorowski Joseph · Wilmington, DEBuilt 2022 · S/N 41729N629JMWebster Bart H · Queen Creek, AZFirst renewal noticeBuilt 2003 · S/N 2232N629KHarrill Roy K · Columbia, SCBuilt 2002 · S/N 23917N629LMackay Restaurant Management Group Inc · Seattle, WABuilt 2003 · S/N 45N629LECloward Max S · Draper, UTBuilt 2021 · S/N 71170N629MBBelleau Clifford D · Anchorage, AKBuilt 2000 · S/N TRB-003
Back to AD 81-18-04 R2