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.

N9213JRegistered aircraftBuilt 1966 · S/N 28-3283N9213KCarver Clarence K · Lutz, FLBuilt 1976 · S/N 28-7625170N9213YCarty Eric · Anchorage, AKBuilt 1971 · S/N 18-8918N92140Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1981 · S/N 15285371N92141High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17261549N9214ATerhune Larry W · Saginaw, TXBuilt 1982 · S/N 38-82A0116N9214FMaule N889z Inc Trustee · Wilmington, DEBuilt 1991 · S/N 4105CN9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationBuilt 1966 · S/N 28-3284N9214SC&L Aviation LLC · New London, WIBuilt 1975 · S/N M-1737N9214VGostomski Michael J · Yacolt, WABuilt 1969 · S/N 690049N9214WManning John · Oro Valley, AZBuilt 1967 · S/N 28-10878N92159Buster Aviation LLC · Harveys Lake, PABuilt 1973 · S/N 17261550N9215DToga LLC · Cumming, GABuilt 1990 · S/N 3213037N9215JGrizzard Shawn C · Hayden, IDS/N 28-3285N9215LDipietro Ian · Westfield, MABuilt 1971 · S/N AA1A-0115N9215SGarner James L DBA · Pelham, ALBuilt 1973 · S/N M1711N9215VGonzalez Cruz · North Las Vegas, NVS/N 690045N92161Skywarrior Flight Training Inc · Pensacola, FLBuilt 1973 · S/N 17261551N92169Welch William Ben · Danville, ILBuilt 1973 · S/N 17261553N9216DBlackbird Aviation LLC · Bedford, PABuilt 1958 · S/N 22-6276N9216HBurgess Alan P · Corona, CABuilt 1975 · S/N 17266020N9216JSantana Alexandre C · Long Beach, CABuilt 1966 · S/N 28-3286N9216LLawrence Guy A · Bakersfield, CAS/N AA1A-0116N9216MLewellen Richard H · Mount Vernon, WABuilt 1966 · S/N 3437N9216NSligh Mark G · Cantil, CABuilt 1968 · S/N 67-16865N9216TLudwigson Joel · Inver Grove Hts, MNBuilt 1978 · S/N 38-78A0279N9217DBischoff Danielle I · Palmer, AKBuilt 1958 · S/N 22-6277N9217EGranberry Philip · Anchorage, AKBuilt 1977 · S/N 7135CN9217JWaicekauskas Joe · Raymondville, MOBuilt 1966 · S/N 28-3287N9217KR & R Air Inc · Wilmington, DEBuilt 1976 · S/N 28-7615183N9217MMullenbach Arnold D · Tucson, AZBuilt 1966 · S/N 3438N9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeBuilt 1967 · S/N 24-4713N9217TRegistered aircraftBuilt 1991 · S/N 14020CN9217WMartin Joe T Jr · Chandler, AZBuilt 1967 · S/N 28-10882N9217XSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1988 · S/N 2841022N9218CArensmeyer Michael W · Longmont, COBuilt 1978 · S/N R18200448N9218DMaestas Jonathan M · Wright City, MOBuilt 1958 · S/N 22-6278N9218RFishe Flying Corp · Vero Beach, FLBuilt 1988 · S/N 2841023N9218SSurette Phillip · Vail, COBuilt 2021 · S/N 72354N9218VTerrell Aviation Inc · Terrell, TXBuilt 1969 · S/N 690051N9218WRitcheson Mark F · Tucson, AZBuilt 1967 · S/N 28-10883N92194Ace Aeromotive Inc · Miami, FLS/N 16635N9219EStahl Randy F · Fort Benton, MTBuilt 1977 · S/N 7140CN9219HKful Flyers Foundation Inc · Fullerton, CABuilt 1975 · S/N 17266021N9219KJones Robert M · Brooksville, FLBuilt 1976 · S/N 28-7690229N9219LHart Gene E · Ridgecrest, CABuilt 1971 · S/N AA1A-0119N9219VChen Brian K · Bakersfield, CABuilt 1969 · S/N 690047N921AARegistration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 17261752N921BBNorthwestern Michigan College · Traverse City, MIBuilt 2024 · S/N 172S13232N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558
Back to AD 81-18-04 R2