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.

N7715DIriarte Christopher P · Grosse Ile, MIBuilt 1957 · S/N 22-5389N7715GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259415N7715NK Heart Aviation LLC · Choudrant, LABuilt 1968 · S/N 28-5162N7715WFoster Kenneth D · Saint Maries, IDBuilt 1964 · S/N 28-1720N7715ZMiller Aviation Inc · Norton, KSBuilt 1966 · S/N 25-3878N77160Fahmy Bishoy F · Fraser, MIBuilt 1973 · S/N 28-7425111N7716GFirst Eclipse Ltd · Richmond, VABuilt 1971 · S/N 17259416N7716JQuinn Andrew · Fort Worth, TXBuilt 1969 · S/N 32-1118N7716NPyanov Mark · Clinton, MSS/N 28-5163N7716WWood Burton T · Richmond Hill, GABuilt 1964 · S/N 28-1721N7716ZBig Aerial Sign Service LLC · Delano, MNBuilt 1966 · S/N 25-3881N77177Nazario Caleb R · Orlando, FLBuilt 1977 · S/N 177RG1118N7717GJohnson Eric C · Turtle Lake, NDBuilt 1970 · S/N 17259417N7717HJohnson Paul C · Tower, MNBuilt 1946 · S/N 12-610N7717JFlying High Aviation LLC · Kalispell, MTBuilt 1969 · S/N 32-1119N7717NAdirondack Flying Club LLC · Rome, NYBuilt 1968 · S/N 28-5160N7717VCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496120N7717WFouse Timothy · Kittanning, PABuilt 1964 · S/N 28-1722N7717ZTumbleweed Leasing Company Inc · Salt Lake City, UTBuilt 2002 · S/N 3373N7718AScud Air 18a LLC · Morgan, UTBuilt 1975 · S/N 27-7554040N7718JPrcs Logistics LLC · South Bound Brook, NJBuilt 1969 · S/N 32-1120N7718NKlinedinst D Eric · Carlisle, PABuilt 1968 · S/N 28-5027N7718PVan Develde Robert K · Troy, MIBuilt 1961 · S/N 24-2931N7718WClyde Fliers Inc · Fremont, OHBuilt 1964 · S/N 28-1724N7719HBurks Richard H · Protem, MOBuilt 1946 · S/N 12-612N7719JMaduro Dudley C · St Thomas, VIFirst renewal noticeBuilt 1969 · S/N 32-1121N7719KHillegeist Tracy L · Beverly, KSBuilt 1950 · S/N 20-541N7719PSchidlowsky Michael · Otis, MABuilt 1961 · S/N 24-2932N7719WKnudson Douglas E · Morris, ILBuilt 1964 · S/N 28-1725N7719XBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4496130N771AAJones Aircraft Co LLC · Cross Plains, TNBuilt 2008 · S/N 0325N771ACMorrison William Fraser · Bonners Ferry, IDS/N 379-96N771BDMcginty Edwin R · Eagle, IDS/N 002N771BZOne Bz LLC · Clarklake, MIBuilt 2012 · S/N 12846N771CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881739N771CBSkycruise Inc · Largo, FLBuilt 1978 · S/N 14378N771CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281781N771EVJamali Elias · Sherwood, ORBuilt 2020 · S/N 74616N771JNSteiner Martin A · Bellaire, OHS/N 680041N771JSRhcp Inc · Virginia Beach, VABuilt 1989 · S/N 004N771KMCouples Therapy LLC · Hampton, NHBuilt 2003 · S/N 1001N771LBLat Of Florida LLC · Winter Park, FLBuilt 1979 · S/N 61P05997963267N771LLBravo November LLC · Wilsonville, ORBuilt 2008 · S/N 1065-2008N771LPRudisaile Joseph · Arlington, TXBuilt 1996 · S/N 101316N771MBMathis Alan L · Moultrie, GAS/N M-1851N771MKHemberger Andrew J · Troy, ILBuilt 2014 · S/N 71279N771MMTaildragger LLC · Lakeside, ORBuilt 2001 · S/N 81258N771MRSmith Nathan · Palmer, AKBuilt 1967 · S/N 87N771NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881036N771PCBuzzair Inc · Wilmington, DEBuilt 1966 · S/N 32-391
Back to AD 81-18-04 R2