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.

N69125Pine Hill Holdings LLC · Richmond, VABuilt 1978 · S/N 15282500N6912JHammond Brian M · Gresham, ORBuilt 1976 · S/N 28-7690427N6912PAnzaldua Johnny J · Midland, TXFirst renewal noticeBuilt 1960 · S/N 24-2046N6912WTop Flight Aviation Snh LLC · Savannah, TNBuilt 1965 · S/N 28-21287N6913Cooper Steven J · Redwood City, CABuilt 1949 · S/N 16-642N6913ANorthwoods Air LLC · Orono, MEBuilt 1979 · S/N 27-7954108N6913BKeyt Jeffrey D · New Providence, NJBuilt 1956 · S/N 22-4188N6913JFlight Time LLC · Conover, NCBuilt 1976 · S/N 28-7690428N6913KMedcroft Sean M · Edmonds, WABuilt 1950 · S/N 20-6N6913NJennings William A · North Little Rock, ARBuilt 1968 · S/N 680138N6913RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 28-8590054N6913SRural Development Corp 1 · Steamboat, COBuilt 1985 · S/N 28-8511010N6913UShaw Brian D · Meadville, PABuilt 1964 · S/N 245N6913WAden James D · Gothenburg, NEBuilt 1965 · S/N 28-21288N69149Joyner Carol M · Claremont, CABuilt 1978 · S/N 15282514N6914AFlyn 6914 Alpha LLC · Oak Island, NCBuilt 1985 · S/N 28-8511011N6914BLark Bradley J · Enoch, UTBuilt 1956 · S/N 22-4189N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429N6914ULiskey John W · Kelseyville, CABuilt 1964 · S/N 246N6914VDuke Terri D · Oakwood, GABuilt 1975 · S/N 22-1294N6914WPearson Timothy M · Waterville, OHBuilt 1965 · S/N 28-21084N69156Lehman Alexander D · Sanford, NCBuilt 1978 · S/N 15282518N6915H2gbs LLC · Wilder, IDBuilt 1975 · S/N 17265640N6915NBaker Stewart D · Severna Park, MDBuilt 1968 · S/N 680139N6915QWilson Kenneth G · Peoria, AZS/N MB-278N6915TSpier Samuel · Carson City, NVBuilt 1985 · S/N 28-8590058N6915VReindollar William Paul Jr · Derwood, MDBuilt 1975 · S/N 22-1295N6915WOso Air LLC · Missoula, MTBuilt 1965 · S/N 28-21086N69165Locaero Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 28-8516060N6916HFms Air LLC · Leesville, LABuilt 1975 · S/N 17265641N6916KBrown Daniel A · Gettysburg, PABuilt 1950 · S/N 20-18N6916NGray Wesley K · Sandia, TXBuilt 1968 · S/N 680140N6916QShawn James R · Pattison, TXS/N MB-287N69173Brs Leasing Inc · Wilmington, DEBuilt 1981 · S/N 15285346N6917APiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 27-7954111N6917DOlds Forge Flyers Inc · Lansing, MIBuilt 1985 · S/N 28-8590061N6917GMarvell Aviation LLC · Marvell, ARBuilt 1985 · S/N 28-8590062N6917NBonak Steven · Punta Gorda, FLBuilt 1968 · S/N 680178N6917VCamper Daniel P II · Port Angeles, WABuilt 1975 · S/N 22-1297N6917WCloutier Michael C · Waddell, AZBuilt 1965 · S/N 28-21088N69187Green Airports Development Corp · Kemah, TXBuilt 1981 · S/N 15285347N69189Lehman David G · Kent, WABuilt 1978 · S/N 15282539N6918DTucker Christopher W · Johnstown, COBuilt 1962 · S/N 23-2038N6918HWright Flight Inc · Tucson, AZBuilt 1975 · S/N 17265642N6918NBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 680141N6918WTopping Warren J · Sagaponack, NYBuilt 1965 · S/N 28-21089N6919BPolyclinics.Net LLC · Hixson, TNS/N 22-4194N6919HTimmester Terry W · Little River, SCBuilt 1975 · S/N 17265643N6919JFlying Is Fun LLC · Atlanta, GABuilt 1976 · S/N 28-7615397N6919MWest Byron Chad · Blue Grass, IABuilt 1985 · S/N 28-8511013
Back to AD 81-18-04 R2