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.

N9448TSanders Robert · Harlingen, TXS/N 38-78A0103N9448WKlein Richard J · Greenville, MIBuilt 1969 · S/N 28-11167N9449DHall Aircraft LLC · Kenai, AKBuilt 1958 · S/N 18-6692N9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeBuilt 1969 · S/N 28R-35164N9449VClark Jeff W · Piedmont, MOBuilt 1970 · S/N 700051N9449WProfessional Pilots Inc · Lowell, INBuilt 1968 · S/N 28-11168N944ATerhune Keith B · Crosby, TXBuilt 1951 · S/N 22-258N944AAWings Over Texas Holdings LLC · Denton, TXBuilt 2013 · S/N 172S11291N944AFStanaski Andrew J · Cary, NCBuilt 2015 · S/N 81675N944AKSulphur Creek Helicopters LLC · George West, TXBuilt 2005 · S/N 10634N944BALatitude 18 Helicopters LLC · Lewes, DES/N 0783N944CBCalifornia Baptist University · Riverside, CABuilt 1973 · S/N 17262402N944CDFlying Easy LLC · Jacksonville, NCBuilt 2009 · S/N 1957N944DPFulton Mark · Elkhorn, NEBuilt 1961 · S/N 1875N944EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12995N944EVSouthlake Aviation LLC · Arden, NCBuilt 2025 · S/N 2881867N944GGraves Charles M · Phoenix, AZBuilt 1987 · S/N 744N944JKRegistered aircraftBuilt 2015 · S/N 001N944KCMustang Sally Aviation LLC · Camden, SCBuilt 2000 · S/N 17280844N944KMMartin Rick H · Las Vegas, NVBuilt 2019 · S/N JA1705106N944LC4lc LLC · Mcminnville, ORBuilt 2003 · S/N 10209N944MRegistered aircraftBuilt 1995 · S/N 2843N944MALjmf 17 LLC · Hays, KSBuilt 2002 · S/N 2211N944PCAlba Leasing Services LLC · Phoenix, AZBuilt 2004 · S/N 10292N944RRancifer Rodney M · Lithonia, GABuilt 1970 · S/N 17258933N944RRJaybee Aviation Ltd · Fort Mill, SCS/N 82544N944SHA & E Aerial LLC · Nashville, ARBuilt 2005 · S/N 10839N944SJMiller David D · Plainfield, ILS/N 1547N944TDiedrick Michael R · Brooksville, FLBuilt 1960 · S/N TD-400N944THSouthern Sky LLC · Henderson, NVBuilt 2024 · S/N 172S13144N944TLAims Community College · Loveland, COBuilt 2019 · S/N 1180-2018N944TTSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2005 · S/N 172S9911N944VCoastal 944v LLC · Wilmington, NCBuilt 1975 · S/N M-1662N944WMMcinerney James William · Park Ridge, ILBuilt 2015 · S/N 92187N944WTHolt Helicopters Inc · Uvalde, TXS/N 10886N94500Training Planes LLC · Tampa, FLBuilt 1983 · S/N 15285692N94505Riverside Flight Center Inc · Tulsa, OKBuilt 1983 · S/N 15285696N9450DSharabi Avinoam · Las Vegas, NVS/N 172RG1166N9450WAirwide LLC · Deerwood, MNBuilt 1968 · S/N 28-11169N94513Hampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 15285702N9451JJackson James E · Denair, CABuilt 1966 · S/N 28-3564N9451LWe Fly High LLC · Helena, MTBuilt 1971 · S/N AA1A-0251N9451NHorus Aviation LLC · Ashburn, VABuilt 1969 · S/N 28R-35166N9451TRegistration Pending · Austin, TXRegistration pendingBuilt 1978 · S/N 38-78A0104N9452EDew Jason L · Krum, TXBuilt 1979 · S/N 17272268N9452HFreeland Thomas W · Early, TXBuilt 1975 · S/N 17266162N9452PRegistered aircraftBuilt 1971 · S/N 24-4959N9452VFriesen Dwayne Phillip · Overton, TXBuilt 1970 · S/N 700052N9452WMarshall Duane C · Rossville, TNS/N 28-11171N94532Oklahoma State University · Stillwater, OKFirst renewal noticeBuilt 1983 · S/N 15285707
Back to AD 81-18-04 R2