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.

N9597ZHanson James A · Bandon, ORS/N 1098N9598AKerr Jerry T · Mount Vernon, WABuilt 1978 · S/N 20A509N9598BIpsen Michael · Kenosha, WIBuilt 1981 · S/N 172RG0909N9598DDurden William L · Tallahassee, FLBuilt 1958 · S/N 22-6506N9598HImsar LLC · Springville, UTBuilt 1975 · S/N 17266256N9598JMardis Andrew · Pelzer, SCBuilt 1966 · S/N 28-3744N9598MBergland John Edward · Santa Monica, CABuilt 1966 · S/N 670175N9598UJackler Leon J · Silver Spring, MDBuilt 1976 · S/N AA5A-0098N9598ZDel Valle Enterprises Inc · Sandpoint, IDBuilt 1989 · S/N 1102N95993Delta State University · Cleveland, MSBuilt 1985 · S/N 15285996N95995Hagele Aviation LLC · Hillsboro, ORBuilt 1985 · S/N 15285997N9599JOrban Kenneth D · Tellico Plains, TNBuilt 1966 · S/N 28-3745N9599KRed Wing Soaring Association · Osceola, WIBuilt 1989 · S/N 1111N9599WNelson Scott G · Lakota, NDS/N 28-23050N9599ZBorn John G · Jupiter, FLBuilt 1989 · S/N 1117N959AANorth Wheeler O · Carlsbad, CABuilt 2001 · S/N 23841N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952N959BWRegistered aircraftBuilt 1981 · S/N R18201706N959CVaero Inc · Vinton, VABuilt 1981 · S/N 27-8154029N959CFCarbonflight LLC · Hermosa Beach, CABuilt 2017 · S/N 1190N959CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281969N959DBSigma Pharmaceuticals LLC · Monticello, IABuilt 1999 · S/N 14095CN959DSDelta State University · Cleveland, MSBuilt 2024 · S/N 321/USN959ERs Specialties LLC · Anchorage, AKBuilt 1955 · S/N 18-4021N959EDDoering Eric A · Litchfield, MNBuilt 2009 · S/N SS-001N959GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881473N959GTR&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15282116N959HCNorthwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 17262361N959JATriple Eagle Aviation LLC · Cambridge, VTBuilt 2007 · S/N 172S10510N959JSSharkey James T · Bennington, VTBuilt 2009 · S/N 001N959PDMilligan Thomas A · Dana, INBuilt 2002 · S/N 1336-2002N959RDDoering Ray A · Devils Tower, WYBuilt 1979 · S/N 18-7909159N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113N959TELawless John M Jr · Tucson, AZBuilt 2004 · S/N 10238N959UAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10526N959YBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12959N95AACoolidge Marvin L · Newberg, ORBuilt 1959 · S/N TD-256N95AFNeville William J III · Marianna, FLBuilt 1971 · S/N 177RG0126N95AHBrown Hunter · Sulphur Rock, ARBuilt 1978 · S/N 18-7809152N95APWingnut Enterprises Inc · Sarasota, FLBuilt 1995 · S/N 32-46012N95AWScotts Air LLC · Prescott, AZBuilt 1996 · S/N 21087N95BEAmundson David Owen · Sioux Falls, SDBuilt 1964 · S/N TD-590N95BJJames William M Jr · Cresson, TXBuilt 1996 · S/N 619N95BNMcphillips Flying Service Inc · Charlevoix, MIBuilt 1969 · S/N 95N95BPPeraton Services LLC · Bozeman, MTBuilt 2012 · S/N 172S11108N95BRChickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 28-25841N95BTCampbell Allen B · Meggett, SCBuilt 2010 · S/N M1A2221N95CHJones Cecil W · Fort Walton Beach, FLBuilt 2020 · S/N 80956N95CJSimmons Marshall · San Antonio, TXBuilt 1960 · S/N TD-334N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896
Back to AD 81-18-04 R2