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.

N6529DG Force Advantage LLC · Lewes, DES/N 17272848N6529PWood Jerrold C · Templeton, MABuilt 1959 · S/N 24-1651N6529UMidwest Mooney Flyers LLC · Indianapolis, INBuilt 1962 · S/N 2312N6529VAhlhorn Travis Wayn · New Braunfels, TXBuilt 1980 · S/N 172RG0755N652ASvendsen Jon A · Wasilla, AKBuilt 1951 · S/N 22-55N652EPChristiansen Aviation LLC · Wilmington, DEBuilt 2016 · S/N 172S11691N652FCFlorida Department Of Agriculture And Consumer Svc · Tallahassee, FLS/N 18282383N652FTFlorida Institute Of Technology Inc · Melbourne, FLBuilt 2024 · S/N 28020170N652GWWilson Gary L · Kingsland, TXBuilt 1999 · S/N 23019N652JPHarvey Gregory D Sr · Greenbush, MEBuilt 1983 · S/N 1066N652MAAbove And Beyond Aviation LLC · Austin, TXBuilt 2000 · S/N 17280903N652MTThomas Michael W · Prescott, WABuilt 1989 · S/N 2043N652NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11468N652PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 187809098N652PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12017N652RHTwohy David S · Osceola, WIBuilt 1976 · S/N 17266850N652RVKracmer Thomas J · Fort Myers, FLBuilt 2012 · S/N 71856N652SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8058N652SRBracy Rodney E · Middleville, MIBuilt 1968 · S/N 17701014N65306Bullet Power Brokers Inc · Stuart, FLBuilt 2004 · S/N 18281420N6530HWagons West LLC · Myrtle Beach, SCBuilt 1975 · S/N 17265477N6530JSalmon Woody W · Chalkyitsik, AKBuilt 1968 · S/N 28-4969N6530RByers Travis M · Villa Rica, GABuilt 1979 · S/N 172RG0199N6530UHeidelberg Haley · Huntington, TXBuilt 1962 · S/N 2313N6530ZElk Mountain Soaring LLC · Bountiful, UTBuilt 1962 · S/N 25-2063N65311Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9695N6531CDorr Juergen W · Mundelein, ILBuilt 1978 · S/N 28-7890380N6531JLoehrer Daniel J · Milbank, SDBuilt 1968 · S/N 28-4970N6531LGaldino Aidan G · Franklin, TNBuilt 1973 · S/N AA1B-0331N6531RBruno Gennaro S · Lewes, DEBuilt 1979 · S/N 172RG0200N65328Lingyun LLC · Winter Garden, FLBuilt 2004 · S/N 18281462N65329Advanced Aviation Group LLC · Frederick, MDBuilt 2004 · S/N 172S9702N6532CQuartarolo Pete · Santa Rosa, CABuilt 1978 · S/N 28-7890381N6532FCouch Walter Jack · Patterson, LAS/N 17273234N6532JGarner Aviation LLC · Tampa, FLS/N 17273885N6532PCarlsson Carl J · Mason City, IABuilt 1960 · S/N 24-1654N65330Flight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 172S9703N65331Maxxum Financial Group Inc · Destrehan, LABuilt 2004 · S/N 172S9704N65339Shaw Andrew G · Huntingdon, PABuilt 1999 · S/N 565N6533JPaulson James L · Lawrenceville, NJBuilt 1968 · S/N 28-4973N6533LNorthcutt Cecil W III · Ponder, TXBuilt 1974 · S/N AA5-0633N6533PRegistered aircraftBuilt 1957 · S/N 24-1655N6533W21 Luna LLC · Phoenix, AZBuilt 1965 · S/N 28-20612N6534BMurphy Timothy · Lake City, FLS/N 1203N6534LAndreassen Andrew R · Pleasanton, NEBuilt 1980 · S/N 15284428N6534PNorwood Comanche Flyers LLC · Quincy, MABuilt 1959 · S/N 24-1656N6534UHuertas Andrew · Van Nuys, CAS/N 2317N65358Peanut Productions LLC · Sheridan, WYBuilt 2004 · S/N 18281424N6535GBbjs Investments LLC · Burlington, WIBuilt 1979 · S/N 17273606N6535HAerial Sign North Inc · Lakewood, NJBuilt 1946 · S/N 19722
Back to AD 81-18-04 R2