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.

N9690KSantana Alexandre C · Long Beach, CAS/N 28-7625190N9690LMarkey James T · Clintondale, NYBuilt 1973 · S/N AA1B-0190N9690MKeefler David A · Queen Creek, AZBuilt 1966 · S/N 670026N9690QRobinson Neil A · Madison, WIBuilt 1975 · S/N 17265774N9690SAck & Co LLC · East Helena, MTBuilt 1966 · S/N 418N9690ULearjetjohn Flying Club LLC · Athens, ALBuilt 1975 · S/N AA5A-0056N9690VAlbrecht William J Jr · Greenville, NCBuilt 1974 · S/N 17264469N9690WCloud Catcher Aviation LLC · Great Falls, MTBuilt 1967 · S/N 28-23161N96911Luciano Edmund R · Anchorage, AKBuilt 1984 · S/N 17276132N9691DSmith Daryl W · Winifred, MTBuilt 1958 · S/N 18-6792N9691JSteinberg Matthew Robert · Wayne, NJBuilt 1967 · S/N 28-3880N9691MBrand Keith E · Sale Creek, TNBuilt 1967 · S/N 670027N9691VNewman Philip · Georgetown, TXBuilt 1974 · S/N 17264470N9692BAberdeen Flying Service · Aberdeen, SDBuilt 1981 · S/N 172RG0971N9692JRegistered aircraftBuilt 1967 · S/N 28-3881N9692PGlass City Aviation Services LLC · Wilmington, DES/N 18-7509036N9692SSymonds Donald M Jr · Dowagiac, MIBuilt 1966 · S/N 126N96932Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 17276136N9693DNewberg Curtis · Willmar, MNBuilt 1958 · S/N 18-6794N9693HClear Creek Aviation LLC · Buffalo, WYBuilt 1975 · S/N 17266318N9693MHiggins Michael · Pasadena, CABuilt 1967 · S/N 670029N9693PStewart Jonah M · Wasilla, AKBuilt 1975 · S/N 18-7509037N9693QHughes Ronnie D · Cedar Park, TXBuilt 1975 · S/N 17265777N9693SSale Reported · Kenmare, NDSale reportedBuilt 1966 · S/N 426N9693VRabideau William J III · Stafford Springs, CTBuilt 1974 · S/N 17264472N9693WDelaney Kevin P · Germantown, TNBuilt 1967 · S/N 28-23165N9694HFitch William R · Dubuque, IABuilt 1975 · S/N 17266319N9694JEli Team 6 Air Services LLC · Madisonville, TNBuilt 1967 · S/N 28-3883N9694LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276598N9694PBocek James C · Sheridan, WYBuilt 1975 · S/N 18-7509038N9694QBexbach North America LLC · Reno, NVBuilt 1975 · S/N 17265778N9694VHaller Patrick C · York, SCBuilt 1974 · S/N 17264473N9694WBertsch Brian · Seeley Lake, MTS/N 28-23166N9695CTrhb Enterprises LLC · Danville, PABuilt 1978 · S/N 32-7840112N9695DPc Flyers LLC · Post Falls, IDBuilt 1959 · S/N 18-6798N9695HGoddard Robert J · Haverhill, MABuilt 1975 · S/N 17266320N9695JVaughn Gary Petty · Sanger, TXBuilt 1967 · S/N 28-3884N9695PTop Hand Inc · Laurel, MTBuilt 1975 · S/N 18-7509039N9695SPearson Lemuel H · Maxwell, CABuilt 1966 · S/N 81N9695TCavallaro Marco · Amarillo, TXBuilt 1978 · S/N 38-78A0157N9696FShakman Michael L Trustee · Chicago, ILBuilt 1998 · S/N 18280269N9696HMirror Image Inc · Belgrade, MTBuilt 1975 · S/N 17266321N9696LAny Border LLC · Yankton, SDBuilt 1986 · S/N 17276599N9696XCurrier Dustan A L · Fairbanks, AKS/N CCK-1865-0061N9697DWarner Carl P · Lindley, NYBuilt 1959 · S/N 22-6607N9697LBroadwell Eric · Woodstock, GABuilt 1973 · S/N AA1B-0197N9697PDubious Adventures II LLC · Big Lake, AKBuilt 1975 · S/N 18-7509040N9697VWestern Edge Aviation LLC · Dickinson, NDBuilt 1974 · S/N 17264476N9697YAfterburner Aviation LLC · Lewes, DEBuilt 1963 · S/N TD-526N9698HEagle Simulator LLC · Lake Oswego, ORBuilt 1975 · S/N 17266322
Back to AD 81-18-04 R2