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.

N573MBWigley Barry L · Langston, ALBuilt 2024 · S/N 26009N573MWWhelan Company LLC · Hoover, ALBuilt 2005 · S/N 90815N573NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10941N573PUTrustees Of Purdue University · West Lafayette, INBuilt 2024 · S/N 4496584N573SMason Scott C · Lebanon, ORBuilt 1976 · S/N 913N573TLAsson David A · Sisters, ORS/N 573N573TMFarley Douglas C · Edmond, OKBuilt 1996 · S/N 001N57401Adams Kenneth · Marana, AZBuilt 1973 · S/N 376-73N57404Cp Aviation Inc · Santa Paula, CABuilt 1973 · S/N 940-73N57405Shoaf Douglas G · Lake Oswego, ORS/N 371-73N57407Britt Elaine L · Locust Grove, GABuilt 1973 · S/N 259-73N57408Phillips Thomas G · Fairbanks, AKBuilt 1973 · S/N 494-73N5740HPritchett Michael L · Benton, ARS/N 16-352N5740QOasis Aero Inc · Willmar, MNBuilt 1965 · S/N 3072N5740UBraden Daniel · Port Charlotte, FLBuilt 1969 · S/N 28-26556N5740WAdams Clay · Anacortes, WABuilt 1963 · S/N 28-1415N5740ZLashley Chad P · Wentzville, MOBuilt 1963 · S/N 22-9579N57410Eddy William Crawford III · Sugar Hill, GABuilt 1973 · S/N 941-73N57411Gregory Larry C Trustee · Farmington, MOBuilt 1973 · S/N 372-73N57412North County Flight Training Inc · Carlsbad, CABuilt 1973 · S/N 495-73N57413Miller Sybille A · Ashburn, VABuilt 1984 · S/N 24-1450N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441N5741FBrower Alan L · Califon, NJBuilt 1968 · S/N 28-25043N5741LWienclaw David E · Boise, IDBuilt 1969 · S/N AA1-0141N5741WGonzalez Jose M · Arlington, TXBuilt 1963 · S/N 28-1435N57420Florida Man Aviation LLC · Saint Petersburg, FLBuilt 1973 · S/N 942-73N57421Snider Roger A · Harlem, MTBuilt 1973 · S/N 498-73N57422Heefner Frederick C · Greencastle, PABuilt 1998 · S/N 23077N57423Pardue Roy S · Clifton, VABuilt 1973 · S/N 92-73N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N57428Zygomalas Stefanos · San Francisco, CABuilt 1973 · S/N 370-73N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442N5742LGjorvad Steven A · Punta Gorda, FLS/N AA1-0142N5742UAdams Sara · Leavenworth, KSBuilt 1970 · S/N 28-26562N5742WJohnson Ronald H · Goodlettsville, TNBuilt 1963 · S/N 28-1428N5742ZBootz Terry A · Canyon Lake, TXBuilt 1984 · S/N 24-1451N57430Swanson Michael D · Council Bluffs, IABuilt 1973 · S/N 944-73N57433Propwash LLC · Princeville, ILBuilt 1973 · S/N 88-73N57435Morkassel Gerald N · Waverly, OHBuilt 1973 · S/N 374-73N5743LHead William J · Verona, KYBuilt 1969 · S/N AA1-0143N5744Keller Kevin M · Sylvania, OHBuilt 2011 · S/N BL1N57440Frankel Daniel A · Madison, OHBuilt 1973 · S/N 946-73N57442Whiting Lawrence M · Silverton, ORBuilt 1973 · S/N 506-73N57446Williams Martin · Wasilla, AKBuilt 1973 · S/N 507-73N57447Hicks Richard Ted · Statesville, NCS/N 263-73N5744DDempsey Timothy P · Pacific, MOBuilt 1956 · S/N 22-4444N5744ULance Sylvia · Acushnet, MABuilt 1970 · S/N 28-26564N5744WGarrett Jackson Trustee · Pleasant Garden, NCBuilt 1963 · S/N 28-1447N57454Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 90-73N57456Marshall James I · Roosevelt, UTBuilt 1973 · S/N 508-73
Back to AD 81-18-04 R2