OpenAirDocs.org
AD 81-12-06 R1

Registered aircraft · 5,102

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-12-06-R1')
    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-12-06-R1')
  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.

N1548XSouthern Turf Services LLC · West Palm Beach, FLBuilt 1975 · S/N 32-7540172N15494Freisitzer Roland Franz · Charlottesville, VAS/N 32-7340045N15498Universal Management And Mainteneance Co Inc · Enid, OKBuilt 1972 · S/N 32-7340010N154BJDent Air Ltd · Annapolis, MDBuilt 1977 · S/N 32R-7780251N154BZGrund Joseph R Jr · North Cape May, NJBuilt 1995 · S/N 27-0195N154DCRocha Jonathan · Prescott Valley, AZBuilt 1969 · S/N 32-40599N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230N15514Smedsmo Darrin A · Roseau, MNS/N 32-7340046N1553XGreat Divide Aircraft LLC · Louisville, COBuilt 1975 · S/N 32R-7680003N15552Crate Inc · Humboldt, NEBuilt 1972 · S/N 32-7340048N15554Hogan James · Winter Garden, FLBuilt 1972 · S/N 32-7340014N1556XMills Donald Lee · Arlington, TNBuilt 1975 · S/N 32-7540124N155AEBissat Rashid H · Visalia, CABuilt 1989 · S/N 27-0014N155EPGogoplex LLC · Wilmington, DEBuilt 1969 · S/N 27-4430N1568WDfb Holdings LLC · Coeur D Alene, IDS/N T18208394N15708Lanza Thomas N · Las Vegas, NVBuilt 1972 · S/N 32-7340058N1572EKorkmaz Fethi A · Asheville, NCS/N 32-7340059N1575XMaring Thomas J · Westley, CABuilt 1975 · S/N 32-7540178N15776Rc & C Inc · Norwalk, IABuilt 1972 · S/N 32-7340064N157CMChamark LLC · Knoxville, TNBuilt 1975 · S/N 32R-7680023N1583XK&T Lawn & Landscape Inc · Newport News, VABuilt 1975 · S/N 32-7540179N15895Ksgj Aircraft LLC · Saint Augustine, FLBuilt 1972 · S/N 32-7340072N158TZBoney George C Jr Trustee · Chapin, SCBuilt 2000 · S/N 20037N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068N15SNRobinson Brian · Bedford, NHBuilt 2001 · S/N 25074CN15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966N160XMalolo LLC · San Luis Obispo, CAS/N 500B-1300-115N161BLAirborne Holdings Inc · Midlothian, TXBuilt 1965 · S/N 1551-197N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106N16253Quincy Aircraft LLC · Quincy, ILS/N 32-7340080N16269Kelley John Charles · Hot Springs Ntl, ARBuilt 1973 · S/N 32-7340081N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228N16372Blue Bird Aviation LLC · Zephyr Cove, NVBuilt 1973 · S/N 32-7340083N163AWMccall Andrew Keith · Abilene, TXBuilt 2002 · S/N T18208163N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221N16415United Aviation LLC · Prospect, KYS/N 32-7340085N164412c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 32-7340087N1646ZDmitry P Kudryn · Wasilla, AKBuilt 1962 · S/N 185-0446N16487Piper Cherokee LLC · Seal Beach, CABuilt 1973 · S/N 32-7340090N16498Owens Hay LLC · Crane, ORBuilt 1973 · S/N 32-7340091N164JAgster Robert J · Fstrvl Trvose, PABuilt 1980 · S/N 32R-8029071
Back to AD 81-12-06 R1