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.

N95646Advantage Aviation Inc · Palo Alto, CABuilt 1985 · S/N 15285951N9564CPowell David K · Edwardsville, ILBuilt 1978 · S/N 28-7890422N9564HLafleur Laurence J · Natick, MABuilt 1975 · S/N 17266232N9564JIrvin Stephanie Michelle · Jacksonville, FLBuilt 1966 · S/N 28-3699N9564MCheung Charlotte · San Jose, CABuilt 1966 · S/N 670141N9565Bailey Gordon J · Fayetteville, GAS/N 088N9565JNebeker Kayla Rae · Murrieta, CABuilt 1966 · S/N 28-3700N9565MBitterroot Ventures LLC · Show Low, AZBuilt 1998 · S/N 18280274N9566BQualitair LLC · MichelstadtBuilt 1981 · S/N 172RG0885N9566DHerbert Brendan A · Portola, CAS/N 22-6483N9566HGarcia Mario · Yuma, AZBuilt 1975 · S/N 17266233N9566LNorth Sound Aviation · Sedro Woolley, WABuilt 1986 · S/N 17276578N9566MRegistered aircraftAssigned, pending cancellationS/N 670143N9566VS D Enterprises Ltd · Brookhaven, NYBuilt 1974 · S/N 17264368N95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILBuilt 1985 · S/N 15285957N9567DFurois Alex D · Bridger, MTBuilt 1958 · S/N 22-6484N9567HCurley Mark L · Alamosa, COBuilt 1975 · S/N 17266234N9567MArrowline Holdings LLC · Brookfield, CTBuilt 1966 · S/N 670144N9567UBerka George · Wilmington, DES/N AA1C0066N9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationBuilt 1974 · S/N 17264369N9567WMiler Aaron L · Chambersburg, PABuilt 1967 · S/N 28-23005N9568Medic Choppers LLC · Springdale, ARBuilt 1972 · S/N 091N9568CMitchell Stephen D · Wichita, KSBuilt 1978 · S/N 28-7890423N9568GTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 17273631N9568JJeep Kenneth M · Wadsworth, ILBuilt 1998 · S/N 18280275N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580N9568MKinney William A · Missouri City, TXBuilt 1966 · S/N 670145N9568URegistration Pending · Bath, PARegistration pendingBuilt 1975 · S/N AA5A-0068N9568VAnderson Zachery D · Bigfork, MTBuilt 1974 · S/N 17264370N9568WSale Reported · Cimarron, KSSale reportedBuilt 1967 · S/N 28-23006N95690Daly Arthur P · El Paso, TXBuilt 2004 · S/N 101N9569FClassic Helicopter Corp · Auburn, WABuilt 1971 · S/N 310461N9569HOsborn Larry R · Summerville, SCBuilt 1975 · S/N 17266235N956CFHighwind Aero LLC · Inyokern, CABuilt 2002 · S/N 18281075N956CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282409N956DCLefthalfplane LLC · Kalispell, MTBuilt 2004 · S/N 752EN956DSDelta State University · Cleveland, MSBuilt 2023 · S/N 225/USN956ERZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 15282201N956ESHr Cabinets LLC · Nederland, TXBuilt 2017 · S/N 18283013N956GTTargonski Gregory · Williamson, GABuilt 2013 · S/N 91433N956JBJ Robb Consulting LLC · Scottsdale, AZBuilt 2004 · S/N 40.390N956JKKrips Jack E Jr · Winter Park, FLBuilt 2014 · S/N 1403N956JWKms Investigations & Consulting LLC · Colleyville, TXBuilt 2021 · S/N 1479-2021N956LBStark Robert C · Hillsboro, ORBuilt 2016 · S/N CCK-1865-0036N956MAAllen William D · Tampa, FLBuilt 1966 · S/N 3431N956MDDigit Aviation LLC · Hampton, NHBuilt 1956 · S/N 18-4884N956MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2022 · S/N 40.1237N956PMSparks James D · Glennallen, AKBuilt 2015 · S/N CH1502N956RHHuston Ben E · Sanger, TXBuilt 2006 · S/N 510-2007N956RVKemph Jeffrey A · Howell, MIBuilt 2008 · S/N 91131
Back to AD 81-18-04 R2